Help,
Here is the problem. I have two columns of data. for example:
Column A
1
3
4
0
2
0
0
3
Column B
Product A
Product A
Product B
Product B
Product A
Product A
Product B
Product B
What I need the function to return is:
Product A - 3
Product B - 2
This is what I thought the function should look like but it is not working:
=IF(A6:A50>0,COUNTIF(A6:A50,"Product A"),0)
If Product A or B did not have any values >0, it would return a zero.
Thanks for any help!
Bookmarks