Help Please: SUMIF function
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
|