| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif formula
XL2007
=SUMIFS(P:P,L:L,"HCAIN",P:P,"0") "Louie" wrote: Hello, I made a formula that looks like this, =SUMIF(L:L,"HCAIN",P:P) however, I need it to sum only the positive numbers and ignore the negative numbers, I am missing something in it and I cant figure it out. thank you for your help! -- Louie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| odd sumif formula | Excel Discussion (Misc queries) | |||
| Sumif Formula | Excel Worksheet Functions | |||
| Formula using SUMIF & IF | Excel Worksheet Functions | |||
| Is there a MAXIF formula similar to the SUMIF formula? | Excel Discussion (Misc queries) | |||
| formula (perhaps sumif?) | Excel Discussion (Misc queries) | |||
Threaded Mode
