Null value in multiple condition formula

  • Thread starter Thread starter Joe Miller
  • Start date Start date
J

Joe Miller

Hi,

I wonder if anybody out there could tell me how to do this?

I am wanting to count the number of times in my worksheet
a cell in column N is empty, WHEN the value of column C
is "C" AND the value of column H (which contains
dd/mm/yyyy data) is within the month of January.

I am using the formula:

=SUMPRODUCT((C2:C100="C")*(MONTH(H2:H100)=1))

to count those cells where Column C = "C" AND the month in
column H = Jan (thanks to you wise and helpful people on
the forum, I might add) but cannot work out how to do the
null value in column N bit!

Any help would be great
thanks
Joe
 
=SUMPRODUCT((C2:C100="C")*(MONTH(H2:H100)=1)*(H2:H100<>"")*(N2:N100))

in case some of H2:H100 is empty. It would even be better to have....

(DATEP(H2:H100)) instead of (H2:H100<>"")

Function DATEP(Cell) As Boolean
Application.Volatile
DATEP = IsDate(Cell)
End Function
 
Back
Top