| 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! |
| 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 | |||
Threaded Mode
