count based on two conditions
 

What formula do I use to see if something meets two conditions.

If any cell in column a = item

and any corresponding cell in column b = sold


I just need to know if there is more than 0 occurences of this

thanks

Josh


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=554301

count based on two conditions
 

"jhahes" wrote in
message ...

What formula do I use to see if something meets two conditions.

If any cell in column a = item

and any corresponding cell in column b = sold


I just need to know if there is more than 0 occurences of this

Use SUMPRODUCT in something like

=SUMPRODUCT((A2:A50="item")*(B2:B50="sold"))

adjust the row span accordingly.