ExcelBanter - COUNTA

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - COUNTA (https://www.excelbanter.com/excel-programming/395989-counta.html)

Axel

COUNTA

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 ***

Mike H

COUNTA

Try:-

=COUNTA(Subs!J4:J1004)-COUNTIF(Subs!J4:J1004,"=*Asco*")

Mike

"Axel" wrote:

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 ***

Axel

COUNTA

Thank's Mike
That works

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

All times are GMT +1. The time now is 12:36 AM.