Conditional Counting is Giving Me Fits!

[JTG]

I just cannot quite crack conditional counting.

My database spans A5:Z300.

Four columns, W, X, Y, Z have dates in some of the cells. The others
are blank.

One column, D, has numbers. They range from 60 to 69, with several
occurrences of each.

I want to count the number of dates in the cells in cells W5:Z300, but
only those in the rows that has a '60' in the same row in column D.

Any help or suggestions would be appreciated.

-Ted

 

[Peo Sjoblom]

One possible way


=SUMPRODUCT((ISNUMBER(W5:Z300))*(D5300=60))

this assumes that if the values in W:Z that are not dates
are either blanks or text, there cannot be any numbers except
for dates. Genuine Excel dates are numbers, if not you can change the
formula to

=SUMPRODUCT((W5:Z300<>"")*(D5300=60))

that would work for text dates assuming the rest of the cells in W:Z are
empty


Regards,

Peo Sjoblom

 

[KC Rippstein]

=SUMPRODUCT((D5300=60)*(W5:Z300<>""))

 

[JTG]

Thank you both for your incredibly fast replies. They worked so I am
good to go.

Thanks again.