| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF FORMULA
Hello, I need to write a formula that sums totals from different sheets but,
I want it to ignore the negative numbers and add only the positive #'s this is what I currently have =SUM('week-1:Week-5'!K12) it gives me a negative total because there are some negative numbers in some cells thank you for your help! -- Louie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif and And formula | Excel Discussion (Misc queries) | |||
| 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) | |||
Threaded Mode
