criteria for two different cells in a count if function
 

I have one column where I want to count if it equals a certain value, I need
to sum all the rols that have that value that are of a certain date that
would be specified in another column, how do I phrase a countif column that
would perform such function? For example Countif column B=0 and column
H=10/1/08....

Thank you for your help, the other items listed were close but nothing that
mentioned this specifically.
--
Judy Rose Cohen

criteria for two different cells in a count if function
 

Try this:

=SUMPRODUCT(--(B1:B10<""),--(B1:B10=0),--(H1:H10=DATE(2008,10,1)))

--
Biff
Microsoft Excel MVP


"Judy Rose" wrote in message
...
I have one column where I want to count if it equals a certain value, I
need
to sum all the rols that have that value that are of a certain date that
would be specified in another column, how do I phrase a countif column
that
would perform such function? For example Countif column B=0 and column
H=10/1/08....

Thank you for your help, the other items listed were close but nothing
that
mentioned this specifically.
--
Judy Rose Cohen

criteria for two different cells in a count if function
 

=SUMPRODUCT(--(ISNUMBER(B2:B100)),--(B2:B100=0),--(H2:H100=DATE(2008,10,1)))

countif won't work given you have multiple criteria in multiple columns

Excel 2007 has a function called COUNTIFS that will work

But the above will work

--


Regards,


Peo Sjoblom

"Judy Rose" wrote in message
...
I have one column where I want to count if it equals a certain value, I
need
to sum all the rols that have that value that are of a certain date that
would be specified in another column, how do I phrase a countif column
that
would perform such function? For example Countif column B=0 and column
H=10/1/08....

Thank you for your help, the other items listed were close but nothing
that
mentioned this specifically.
--
Judy Rose Cohen