count based on two conditions

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
 
I

ikr

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count if two conditions in two arrays are true 1
I need to add column based on two conditions using Excel 2003 4
Format cells based on two conditions 4
COUNT for 2 or MORE CONDITIONS 5
A Huge Conditional Format Challenge.... 2
Is there an equivalent function? 4
poplulate cell based on two conditions 3
Active cell is to jump from one cell to another when conditions are met 2

Top