Count If
One way ..
Assume this data is in Sheet1
A B
1 Sales
2 Supply 3
3 Sales 3
4 Supply
In Sheet2
-------------
Put in A1: Sales, in A2: Supply, etc
Put in B1:
=SUMPRODUCT((Sheet1!$A$1:$A$100=TRIM(A1))*ISBLANK( Sheet1!$B$1:$B$100))
Copy down
Col B will return the number of "blank" Sales, Supply, etc from Sheet1
Adapt the ranges to suit ..
(but note that you can't use entire col references "A:A, B:B" etc in
SUMPRODUCT )
--
Rgds
Max
xl 97
--
Please respond, in newsgroup
xdemechanik <atyahoo<dotcom
---
"KAnoe" wrote in message
...
I would like to Count the Sales Only that DO Not Have a Sale in B. So it
would only count the Blank sales.
A B
1 Sales
2 Supply 3
3 Sales 3
4 Supply
Total With No Sales:1
Any help would be great!!
|