count based on two conditions

  • Thread starter Thread starter jhahes
  • Start date Start date
J

jhahes

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 said:
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
Click to expand...

Use SUMPRODUCT in something like

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

adjust the row span accordingly.
 
Back
Top