A
Axel
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
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