S
ShimiCocoPop
I am using
=INT((Current Date - DOB)/365.25)
to count age...
I want to use
=SUMPRODUCT(--(Type="D"),--(Age="25"))
It shows ZERO when I do this... I'm guessing its because
there is a formula calculating the information in the age
column.
Any ideas how I can combine these data and find out how
many twenty-five year olds bought product D?
=INT((Current Date - DOB)/365.25)
to count age...
I want to use
=SUMPRODUCT(--(Type="D"),--(Age="25"))
It shows ZERO when I do this... I'm guessing its because
there is a formula calculating the information in the age
column.
Any ideas how I can combine these data and find out how
many twenty-five year olds bought product D?