Help

[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?

 

[Jason Morin]

If you're calculating age, the results will be numbers.
Try =25 rather than ="25" in your SUMPRODUCT formula.

HTH
Jason
Atlanta, GA

 

[jeff]

HI,

REmove the Quotes around 25:

'=SUMPRODUCT(--(Type="D"),--(Age=25))

jeff