two cases for countif
 

I have this formula right now at this moment
=SUMPRODUCT(--(A3:A88="cell"),--(D388="no"),B3:B88) i want to know if
you can use countif with this same format. because the sumproduct
formula works if the 2 cases are true I want to know if you can have
two cases in a countif formula


--
joi2
------------------------------------------------------------------------
joi2's Profile: http://www.excelforum.com/member.php...o&userid=27554
View this thread: http://www.excelforum.com/showthread...hreadid=483121

two cases for countif
 

No



--

Regards,

Peo Sjoblom



"joi2" wrote in message
...

I have this formula right now at this moment
=SUMPRODUCT(--(A3:A88="cell"),--(D388="no"),B3:B88) i want to know if
you can use countif with this same format. because the sumproduct
formula works if the 2 cases are true I want to know if you can have
two cases in a countif formula


--
joi2
------------------------------------------------------------------------
joi2's Profile:
http://www.excelforum.com/member.php...o&userid=27554
View this thread: http://www.excelforum.com/showthread...hreadid=483121