Formula want work

[drose]

can you tell me why this wont work? I am trying to find how many days in
column H2:H232 are less than 8 if in column D2232 the month is January. I
used the formula below as an array formula but it is just counting all of the
days and not the one's less than 8.

{=COUNT(IF(D2232="January",H2:H232,"<8"))}

 

[Mike H]

Maybe

=SUMPRODUCT((D225="January")*(H2:H25<8))

Mike

 

[Max]

This would likely cover it better here:
=SUMPRODUCT((TEXT(D225,"mmmm")="January")*(D225<>"")*(H2:H25<8)*(H2:H25<>""))

Your data vis-a-viz count criteria issues could be:
1. You have real dates in col D, not text: January
2. There are blank cells in either/both cols D & H
Any blank cells will be evaluated as a real date in "January" (affects col
D's checks) or as a zero in calcs (affects col H's checks)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik