SUMIF not summing

  • Thread starter Thread starter Richard Monk
  • Start date Start date
R

Richard Monk

Here is my simple formula...

=SUMIF(A1:A4,C1:C4,E1:E4)

A1:A4 contain dates

C1:C4 contain duplicate dates

E1:E4 each contains £10

Therefore the sum should be £40, however SUMIF returns a
value of £0.00

For some reason, using Excel 2000, this works fine,
however on 2002, it always returns a value of £0.00

Suggestions please.
 
Richard,

I tried, as an array and a regular formula, and could not get your formula
to work in XL2000

However, either of these will work for you.

=SUM(IF(A1:A5,B1:B5,C1:C5)) array entered (Ctrl+Shift+Enter)

Or

=SUMPRODUCT((A1:A5=B1:B5)*(C1:C5))

PC


Here is my simple formula...

=SUMIF(A1:A4,C1:C4,E1:E4)

A1:A4 contain dates

C1:C4 contain duplicate dates

E1:E4 each contains £10

Therefore the sum should be £40, however SUMIF returns a
value of £0.00

For some reason, using Excel 2000, this works fine,
however on 2002, it always returns a value of £0.00

Suggestions please.
 
Cheers guys, SUMPRODUCT works a treat, I will now apply
that to the main spreadsheet that I am creating.

Curiosly, I had it wrong regarding XL2000, it was actually
XL2002 (like mine), only operating on a diff machine. I
use Win XP Pro, and the other machine uses Win 2k, if that
makes any difference. I have the file if anyone is
interested in taking a look?

Also, it is there a workaround using SUMIF for entering
the criteria using the "like" option or asterisk *?

ie SUMIF(a1:a5, "*example*", c1:c5)
 
Back
Top