SUMIFS Issue

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I'm trying to do a sumifs with two criteria. Below is my data and equation.

ID COUNT SUM FIRST 4 LAST 2
010100 1 $40,000.00 0101 00
010101 7 $194,230.00 0101 01
010102 2 $60,000.00 0101 02
010201 4 $120,000.00 0102 01

0101
00

=SUMIFS(B2:B5,D2:D5,A7,E2:E5,"<>"&A8)

A7 = 0101 and A8=00

The IDs are formatted as text (to keep the leading zeroes). The equation is
currently giving me 10 but it should be 9. When I change the second criteria
to equals A8 it works and gives me 1. I've also made IF equations that check
A7 & A8 against the First 4 & Last 2 columns and they behave as they should.
This is only happens in the SUMIFS equation. Any ideas?

Thanks
Chris


.

Relevant Pages

  • Re: sumifs in excel 2003
    ... It is common to put all the criteria first, ... I am using, perhaps, a more advanced usage of the SUMIFS formula. ... Mike H's formula would produce different numeric results (treating Boolean ... zero when EVERY entry in A1:A20 were 1000 AND EVERY entry in B1:B20 were ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Multiple "IF" or Conditions
    ... I noticed that the SUMIFS ... allow multiple criteria which would suit you perfectly. ... charging me money for a specific issue. ... to 3 companies charging me money. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: SUMIFS error
    ... I have errors doing SUMIFS function. ... Table AMOUNT is formated as number ... If I use SUMIF with criteria #2, ...
    (microsoft.public.excel.misc)
  • Re: SUMIFS error
    ... "Dave Peterson" wrote: ... I have errors doing SUMIFS function. ... Table AMOUNT is formated as number ... If I use SUMIF with criteria #2, ...
    (microsoft.public.excel.misc)
  • RE: sumif
    ... --For a single criteria SUM you can use ... --When you have multiple criteria use SUMPRODUCT() ... If you are using Excel 2007 you can use SUMIFS() to acheive the same result ...
    (microsoft.public.excel.worksheet.functions)