| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF with various criteria
I am using the following formulat to get the number of Boys from London
between the ages of 5 and 12. =SUMPRODUCT(--($D$3:$D$986="B"),--($F$3:$F$986=512),--($H$3:$H$986="London")) I must have done something wrong because I am not getting anything that makes sense. Can someone help please? Thank you -- NitaMax |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF with various criteria
Try this:
=SUMPRODUCT(--($D$3:$D$986="B"),--($F$3:$F$986=5),--($F$3:$F$986<=12),--($H$3:$H$986="London")) Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "NitaMax" wrote in message ... I am using the following formulat to get the number of Boys from London between the ages of 5 and 12. =SUMPRODUCT(--($D$3:$D$986="B"),--($F$3:$F$986=512),--($H$3:$H$986="London")) I must have done something wrong because I am not getting anything that makes sense. Can someone help please? Thank you -- NitaMax |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF with various criteria
Well, for one thing, this portion makes no sense: --($F$3:$F$986=512)
Those values that are equal to 5 are by definition not greater than 12. What are you trying to do with that? Dave On Oct 2, 3:15 pm, NitaMax wrote: I am using the following formulat to get the number of Boys from London between the ages of 5 and 12. =SUMPRODUCT(--($D$3:$D$986="B"),--($F$3:$F$986=512),--($H$3:$H$986="London*")) I must have done something wrong because I am not getting anything that makes sense. Can someone help please? Thank you -- NitaMax |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF with various criteria
It is coming up with a total greater than the number of people I have.
-- NitaMax "Ron Coderre" wrote: Try this: =SUMPRODUCT(--($D$3:$D$986="B"),--($F$3:$F$986=5),--($F$3:$F$986<=12),--($H$3:$H$986="London")) Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "NitaMax" wrote in message ... I am using the following formulat to get the number of Boys from London between the ages of 5 and 12. =SUMPRODUCT(--($D$3:$D$986="B"),--($F$3:$F$986=512),--($H$3:$H$986="London")) I must have done something wrong because I am not getting anything that makes sense. Can someone help please? Thank you -- NitaMax |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF with various criteria
I want the boys from London aged between 5 and 12.
I tried and failed so far. -- NitaMax "Dave F" wrote: Well, for one thing, this portion makes no sense: --($F$3:$F$986=512) Those values that are equal to 5 are by definition not greater than 12. What are you trying to do with that? Dave On Oct 2, 3:15 pm, NitaMax wrote: I am using the following formulat to get the number of Boys from London between the ages of 5 and 12. =SUMPRODUCT(--($D$3:$D$986="B"),--($F$3:$F$986=512),--($H$3:$H$986="London-")) I must have done something wrong because I am not getting anything that makes sense. Can someone help please? Thank you -- NitaMax |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF with various criteria
I tried the formula. It is giving me the correct answer. Are you sure you
entered it properly? "NitaMax" wrote in message ... It is coming up with a total greater than the number of people I have. -- NitaMax "Ron Coderre" wrote: Try this: =SUMPRODUCT(--($D$3:$D$986="B"),--($F$3:$F$986=5),--($F$3:$F$986<=12),--($H$3:$H$986="London")) Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "NitaMax" wrote in message ... I am using the following formulat to get the number of Boys from London between the ages of 5 and 12. =SUMPRODUCT(--($D$3:$D$986="B"),--($F$3:$F$986=512),--($H$3:$H$986="London")) I must have done something wrong because I am not getting anything that makes sense. Can someone help please? Thank you -- NitaMax |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF with various criteria
I did a cut and paste. When doing the total for boys and girls I still end
up with a total greater than I expect. -- NitaMax "Wondering" wrote: I tried the formula. It is giving me the correct answer. Are you sure you entered it properly? "NitaMax" wrote in message ... It is coming up with a total greater than the number of people I have. -- NitaMax "Ron Coderre" wrote: Try this: =SUMPRODUCT(--($D$3:$D$986="B"),--($F$3:$F$986=5),--($F$3:$F$986<=12),--($H$3:$H$986="London")) Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "NitaMax" wrote in message ... I am using the following formulat to get the number of Boys from London between the ages of 5 and 12. =SUMPRODUCT(--($D$3:$D$986="B"),--($F$3:$F$986=512),--($H$3:$H$986="London")) I must have done something wrong because I am not getting anything that makes sense. Can someone help please? Thank you -- NitaMax |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CountIf with 2 criteria possible? | Excel Discussion (Misc queries) | |||
| Countif with Two Criteria | Excel Worksheet Functions | |||
| Countif W/ 2 Criteria | Excel Worksheet Functions | |||
| Countif using format criteria not number criteria? | Excel Worksheet Functions | |||
| Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
Linear Mode
