| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Countif two criteria
Hi Everyone,
I would like to be able to count the number of females with a score in C. so using Countif how do I say countif B = F and C equals a number? I'd be grateful for any ideas how to do this. Could I use Sumproduct as an alternative to countif? Thanking you in advance -- Mifty |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using Countif two criteria
"Mifty" wrote in message
... Hi Everyone, I would like to be able to count the number of females with a score in C. so using Countif how do I say countif B = F and C equals a number? I'd be grateful for any ideas how to do this. Could I use Sumproduct as an alternative to countif? Thanking you in advance -- Mifty Try something like =SUMPRODUCT((B1:B100="F")*(C1:C1000)) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using Countif two criteria
You can use COUNTIF if you only have one condition. In this case try:
=SUMPRODUCT((B1:B100="F")*(ISNUMBER(C1:C100)) Hope this helps. Pete On Nov 19, 10:49 am, Mifty wrote: Hi Everyone, I would like to be able to count the number of females with a score in C. so using Countif how do I say countif B = F and C equals a number? I'd be grateful for any ideas how to do this. Could I use Sumproduct as an alternative to countif? Thanking you in advance -- Mifty |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using Countif two criteria
Maybe
=SUMPRODUCT((B1:B20="F")*(ISNUMBER(C1:C20))) Mike "Mifty" wrote: Hi Everyone, I would like to be able to count the number of females with a score in C. so using Countif how do I say countif B = F and C equals a number? I'd be grateful for any ideas how to do this. Could I use Sumproduct as an alternative to countif? Thanking you in advance -- Mifty |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using Countif two criteria
Thank you to Stephen, Pete and Mike.
Sumproduct seems quite a useful function Cheers -- Mifty "Mifty" wrote: Hi Everyone, I would like to be able to count the number of females with a score in C. so using Countif how do I say countif B = F and C equals a number? I'd be grateful for any ideas how to do this. Could I use Sumproduct as an alternative to countif? Thanking you in advance -- Mifty |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using Countif two criteria
Thanks for feeding back - see here for further details on the use of
SUMPRODUCT: http://www.xldynamic.com/source/xld.SUMPRODUCT.html Hope this helps. Pete On Nov 19, 11:18 am, Mifty wrote: Thank you to Stephen, Pete and Mike. Sumproduct seems quite a useful function Cheers -- Mifty "Mifty" wrote: Hi Everyone, I would like to be able to count the number of females with a score in C. so using Countif how do I say countif B = F and C equals a number? I'd be grateful for any ideas how to do this. Could I use Sumproduct as an alternative to countif? Thanking you in advance -- Mifty- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF with various criteria | Excel Discussion (Misc queries) | |||
| Countif with more than one criteria | Excel Discussion (Misc queries) | |||
| CountIf - 2 Criteria | Excel Discussion (Misc queries) | |||
| Countif using format criteria not number criteria? | Excel Worksheet Functions | |||
| Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
Linear Mode
