| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
COUNTA
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CountA | Excel Discussion (Misc queries) | |||
| Counta | Excel Discussion (Misc queries) | |||
| Counta | Excel Worksheet Functions | |||
| COUNTA | Excel Worksheet Functions | |||
| COUNTA Function not working =COUNTA(C3:C69,"NH") | Excel Worksheet Functions | |||
Linear Mode
