View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
baz
 
Posts: n/a
Default 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