Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
will countif work for this?
I'm trying to count cells in a row that have '100%' in them from a formula.
I've tried naming the cells that I want (E6, H6, M6, P6) and use: =countif(name, 100%) It's not working for me... Suggestions? Thanks. Steve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
will countif work for this?
=COUNTIF(E6:P6,"100%")
or =COUNTIF(E6:P6,1) On Oct 23, 7:25*pm, Skeeterj wrote: I'm trying to count cells in a row that have '100%' in them from a formula. I've tried naming the cells that I want (E6, H6, M6, P6) and use: =countif(name, 100%) It's not working for me... *Suggestions? Thanks. Steve |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
will countif work for this?
=COUNTIF(C6:p6,100%)
"Skeeterj" wrote: I'm trying to count cells in a row that have '100%' in them from a formula. I've tried naming the cells that I want (E6, H6, M6, P6) and use: =countif(name, 100%) It's not working for me... Suggestions? Thanks. Steve |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
will countif work for this?
=COUNTIF(A1:A7,1)
The 100% is set as the number 1 as 0.99 = 99% etc. I tried this, and it counts the number of 100%'s Regards Skeeterj wrote: I'm trying to count cells in a row that have '100%' in them from a formula. I've tried naming the cells that I want (E6, H6, M6, P6) and use: =countif(name, 100%) It's not working for me... Suggestions? Thanks. Steve -- Matt Lynn Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200910/1 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
will countif work for this?
No countif can't do that on a non contiguous range, Try this
=SUMPRODUCT(COUNTIF(INDIRECT({"E6","H6","M6","P6"} ),"=100%")) Mike "Skeeterj" wrote: I'm trying to count cells in a row that have '100%' in them from a formula. I've tried naming the cells that I want (E6, H6, M6, P6) and use: =countif(name, 100%) It's not working for me... Suggestions? Thanks. Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF doesn't work | Excel Discussion (Misc queries) | |||
why doesn't this countif work? | Excel Programming | |||
Will countif work? | Excel Programming | |||
How to get Countif to work this out? | Excel Worksheet Functions | |||
Countif does not work | Excel Worksheet Functions |