| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
two condition formula
I am trying to count column "a" when a condition is true and then count
column "j" when the number is a negative. I have tried =COUNTIF(B9:B23,"=COMP")+COUNTIF(J7:J22,""<0) but I do not get the answer it should be. Column "b is words and column "J is number that are negative so that why I choose <0. Column B will have multiple names and column J is the difference in late days. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
two condition formula
Hi Linda
Try the below =SUMPRODUCT((B9:B23="COMP")*(J9:J23<0)) If you are using XL2007 try help on COUNTIFS() -- Jacob (MVP - Excel) "linda" wrote: I am trying to count column "a" when a condition is true and then count column "j" when the number is a negative. I have tried =COUNTIF(B9:B23,"=COMP")+COUNTIF(J7:J22,""<0) but I do not get the answer it should be. Column "b is words and column "J is number that are negative so that why I choose <0. Column B will have multiple names and column J is the difference in late days. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add condition to =MAX formula | Excel Discussion (Misc queries) | |||
| Condition formula | Excel Discussion (Misc queries) | |||
| Please Help Again-Condition Formula | Excel Worksheet Functions | |||
| Formula For If & Or Condition | Excel Discussion (Misc queries) | |||
| Add condition to formula | Excel Worksheet Functions | |||
Linear Mode
