Forum Discussion
MarkS1850
Aug 15, 2024Copper Contributor
calculating an age range across multiple sheets
I am trying to extrapolate an age range (i.e. 20-29) using information contained with in the same columns but on different sheets. I tried to find the value of age 20 on a single sheet using the for...
MarkS1850
Aug 15, 2024Copper Contributor
JKPieterse Thank you for responding. The column I am searching has values that were discovered using a formula to calculate age based on birthday vs current day: =DATEDIF(M38, TODAY(),"Y"). I tried you suggestion and I am not sure what was supposed to happen. The cell I wanted to collect the total number of cells with the age "80" (I used that number because I knew there were more than one appearance of that age with in the column). The cell that I typed the formula in did not record the number of times that age appeared. Actually, it did not record anything.
JKPieterse
Aug 16, 2024Silver Contributor
What happens if you remove the quotes around the age you are looking for from the formula? It now counts cells with the text "20" in them, which is different from cells with the number 20.