Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am using Excel 2003.
I have one SUMIF function that works just fine. However I wan to add a second argument to work in conjunction with the first. Example: =SUMIF (D1:D200, Fred, Totals) works fine. I want to use this in conjunction with looking at E1:E200 where criteria equals 54321, and still summing the "Totals" sum_range. Fred may have 75 returns with a total of 423 using the first example but only 34 returns when I look for the second criteria with a total of 65. I tried nesting but I'm just not getting it. I'd appreciate any help in getting. Please post as email is bogus to prevent spam. Thanks in advance for any help. baz |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
SumIF function | Excel Discussion (Misc queries) | |||
Sumif function with remote cell references | Excel Worksheet Functions | |||
SUMIF function | Excel Worksheet Functions | |||
SUMIF function | Excel Worksheet Functions |