Hi
but this is what his formula would do?
hardcoded alternative:
=SUMPRODUCT((A1:A100="Sales)*ISBLANK(B1:B100))
Also see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
Regards
Frank Kabel
Frankfurt, Germany
"KAnoe" schrieb im Newsbeitrag
...
MAX I would like it to Only Count the Blank "Sales" Only.
Can this be done?
Thanks for your Help!!!!!!
"Max" wrote:
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!!