Hi guys,
Let's get to the point:
ColumnA ColumnB
1.99 5
2.99 5
3.99 5
1.99
2.99 5
3.99 5
1.99 5
2.99 5
3.99 5
O.K. simple question: I have the price of 1.99 listed three times, but the quantity is only there two times. How can I write a formula to COUNT the number of instances where Column A is 1.99 AND where column B is greater than 0?
In this case the formula should return 2, since only two "records" have 1.99 AND a quantity greater than 0.
I tried using AND and countif, but can't get it to work...
Any help is appreciated!!
Thanks!
Let's get to the point:
ColumnA ColumnB
1.99 5
2.99 5
3.99 5
1.99
2.99 5
3.99 5
1.99 5
2.99 5
3.99 5
O.K. simple question: I have the price of 1.99 listed three times, but the quantity is only there two times. How can I write a formula to COUNT the number of instances where Column A is 1.99 AND where column B is greater than 0?
In this case the formula should return 2, since only two "records" have 1.99 AND a quantity greater than 0.
I tried using AND and countif, but can't get it to work...
Any help is appreciated!!
Thanks!