J
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
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