| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to count *'s that i have put in my sheet ?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want to count *'s that i have put in my sheet ?
Precede with a tilde to make it work
=COUNTIF(A:A,"~*") -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "harry cheema" <harry wrote in message ... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want to count *'s that i have put in my sheet ?
Thanks for Help
But not =COUNTIF(A:A,"~*") BUT =COUNTIF(A:A,"**") WORKS. THANKS PEO HARRY "Peo Sjoblom" wrote: Precede with a tilde to make it work =COUNTIF(A:A,"~*") -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "harry cheema" <harry wrote in message ... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want to count *'s that i have put in my sheet ?
Not really unless you really wanted to count all cells that are not empty
=COUNTIF(A:A,"~*") will count cells that contain the asterisk and nothing else -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "harry cheema" wrote in message ... Thanks for Help But not =COUNTIF(A:A,"~*") BUT =COUNTIF(A:A,"**") WORKS. THANKS PEO HARRY "Peo Sjoblom" wrote: Precede with a tilde to make it work =COUNTIF(A:A,"~*") -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "harry cheema" <harry wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rookie at linking - need a tudor!!! | Excel Worksheet Functions | |||
| Auto "copy and paste" individual cells from various sheets into one sheet ?? | Excel Discussion (Misc queries) | |||
| lock tab in sheet 2 until cell in sheet one is completed | Excel Worksheet Functions | |||
| How to get a row consecutive from a sheet to another | Excel Worksheet Functions | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
Linear Mode
