| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif does not work
Hi appreciate help on getting Countif to work on this situation:
=80% =80% =100% <60% Formula is COUNTIF(A5:A8,G11), where A5:A8 is the table above, and G11 contains =80%. how do I set a formula to calculate that there are two counts of "=80%"? the value returned is zero instead of 2 counts. I did a =A5=G11, which returned a TRUE. Regards |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif does not work
Try this:
=COUNTIF(A5:A8,"="&G11) Does that help? *********** Regards, Ron XL2002, WinXP "c4ec" wrote: Hi appreciate help on getting Countif to work on this situation: =80% =80% =100% <60% Formula is COUNTIF(A5:A8,G11), where A5:A8 is the table above, and G11 contains =80%. how do I set a formula to calculate that there are two counts of "=80%"? the value returned is zero instead of 2 counts. I did a =A5=G11, which returned a TRUE. Regards |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif does not work
Thanks Ron, it works.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CountIf should work across sheets | Excel Worksheet Functions | |||
| SUMPRODUCT vs. COUNTIF -- Why does one work? | Excel Worksheet Functions | |||
| Need Countif to work like Sumif | Excel Worksheet Functions | |||
| Countif + vLookup: Can they work together? | Excel Discussion (Misc queries) | |||
| countif(a1:a12,">TODAY()") How do I get this to work? | Excel Worksheet Functions | |||
Linear Mode
