Hi!
I am trying to make a formula that count all none empty cells in a
range, but if the cell contain "Asco", it shall not be counted.
This din't work
=COUNTA(Subs!J4:J1004;-(COUNTA(Subs!J4:J1004;"*Asco*")*2))
Any suggestion?

Thanks

Aksel

*** Sent via Developersdex http://www.developersdex.com ***