| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I combine 2 COUNTIF formulas??
These are my formulas: =COUNTIF(Mo!D8:D53,"PM") =COUNTIF(J8:J53,"100%")
Both formulas work how I want them to separately, but I can't combine them. I need them to only count if both are true. I need it only to count if it is a "PM" and "100%", it needs to be both! Help! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I combine 2 COUNTIF formulas??
Try this:
=SUMPRODUCT((Mo!D8:D53="PM")*(J8:J53="100%")) If the values in ColJ are numeric, then you may need to use this: =SUMPRODUCT((Mo!D8:D53="PM")*(J8:J53=100%)) Does that help? *********** Regards, Ron XL2002, WinXP-Pro "MANDY" wrote: These are my formulas: =COUNTIF(Mo!D8:D53,"PM") =COUNTIF(J8:J53,"100%") Both formulas work how I want them to separately, but I can't combine them. I need them to only count if both are true. I need it only to count if it is a "PM" and "100%", it needs to be both! Help! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I combine 2 COUNTIF formulas??
It didn't work, came up #NAME?
"Ron Coderre" wrote: Try this: =SUMPRODUCT((Mo!D8:D53="PM")*(J8:J53="100%")) If the values in ColJ are numeric, then you may need to use this: =SUMPRODUCT((Mo!D8:D53="PM")*(J8:J53=100%)) Does that help? *********** Regards, Ron XL2002, WinXP-Pro "MANDY" wrote: These are my formulas: =COUNTIF(Mo!D8:D53,"PM") =COUNTIF(J8:J53,"100%") Both formulas work how I want them to separately, but I can't combine them. I need them to only count if both are true. I need it only to count if it is a "PM" and "100%", it needs to be both! Help! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I combine 2 COUNTIF formulas??
#NAME sounds unlikely. Did you spell the function correctly?
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "MANDY" wrote in message ... It didn't work, came up #NAME? "Ron Coderre" wrote: Try this: =SUMPRODUCT((Mo!D8:D53="PM")*(J8:J53="100%")) If the values in ColJ are numeric, then you may need to use this: =SUMPRODUCT((Mo!D8:D53="PM")*(J8:J53=100%)) Does that help? *********** Regards, Ron XL2002, WinXP-Pro "MANDY" wrote: These are my formulas: =COUNTIF(Mo!D8:D53,"PM") =COUNTIF(J8:J53,"100%") Both formulas work how I want them to separately, but I can't combine them. I need them to only count if both are true. I need it only to count if it is a "PM" and "100%", it needs to be both! Help! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I combine 2 COUNTIF formulas??
Yes I did. I've tried just about everything I can think of. Thanks for the
help. "Bob Phillips" wrote: #NAME sounds unlikely. Did you spell the function correctly? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "MANDY" wrote in message ... It didn't work, came up #NAME? "Ron Coderre" wrote: Try this: =SUMPRODUCT((Mo!D8:D53="PM")*(J8:J53="100%")) If the values in ColJ are numeric, then you may need to use this: =SUMPRODUCT((Mo!D8:D53="PM")*(J8:J53=100%)) Does that help? *********** Regards, Ron XL2002, WinXP-Pro "MANDY" wrote: These are my formulas: =COUNTIF(Mo!D8:D53,"PM") =COUNTIF(J8:J53,"100%") Both formulas work how I want them to separately, but I can't combine them. I need them to only count if both are true. I need it only to count if it is a "PM" and "100%", it needs to be both! Help! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I combine 2 COUNTIF formulas??
It did work!! There was a problem in the spreadsheet, not the formula! Thanks
guys you've been great. "MANDY" wrote: Yes I did. I've tried just about everything I can think of. Thanks for the help. "Bob Phillips" wrote: #NAME sounds unlikely. Did you spell the function correctly? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "MANDY" wrote in message ... It didn't work, came up #NAME? "Ron Coderre" wrote: Try this: =SUMPRODUCT((Mo!D8:D53="PM")*(J8:J53="100%")) If the values in ColJ are numeric, then you may need to use this: =SUMPRODUCT((Mo!D8:D53="PM")*(J8:J53=100%)) Does that help? *********** Regards, Ron XL2002, WinXP-Pro "MANDY" wrote: These are my formulas: =COUNTIF(Mo!D8:D53,"PM") =COUNTIF(J8:J53,"100%") Both formulas work how I want them to separately, but I can't combine them. I need them to only count if both are true. I need it only to count if it is a "PM" and "100%", it needs to be both! Help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif formulas change after doing a sort | Excel Worksheet Functions | |||
| Combine 2 formulas | Excel Worksheet Functions | |||
| Help combine 2 formulas into 1 | Excel Worksheet Functions | |||
| Combine two formulas in one cell | Excel Discussion (Misc queries) | |||
| combining countif formulas | Excel Worksheet Functions | |||
Linear Mode
