Formula want work

  • Thread starter Thread starter drose
  • Start date Start date
D

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 D2:D232 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(D2:D232="January",H2:H232,"<8"))}
 
This would likely cover it better here:
=SUMPRODUCT((TEXT(D2:D25,"mmmm")="January")*(D2:D25<>"")*(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
 
Back
Top