Re: SUMIF? Or other?

From: "Bob Phillips" <bob.NGs@xxxxxxxxxxxxx>
Date: Wed, 26 Mar 2008 13:17:21 -0000

=SUMPRODUCT((A4:A50=A52)*(D4:J50))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Ken" <Ken@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0B7F9C71-B87B-4B72-9AED-783A2ED1C98F@xxxxxxxxxxxxxxxx

Excel2003 ...

Range A4:A50 ... contains Text (may repeat)
Range D4:J50 .... contains numbers
Range A52:A57 ... contains "unique" Text from Range A4:A50

I want to sum all the values in Range D4:J50 when the value in Range
A4:A50
matches "unique" value in Range A52:A57.

My 1st formula is ... =Sumif(A4:A50,A52,D4:J50) ... but it is not
returning
value I expect.

Col A ..... Col D thru Col J

aaaa 1 - 3 - 0 - 3 - 0 - 0 - 0
bbbb 0 - 0 - 0 - 1 - 0 - 0 - 4
aaaa 2 - 1 - 2 - 0 - 1 - 1 - 1
cccc 4 - 2 - 0 - 0 - 2 - 1 - 0
aaaa 3 - 0 - 1 - 1 - 1 - 1 - 2
bbbb 1 - 2 - 1 - 2 - 0 - 2 - 1

Unique ... (return value I wish)

aaaa ... = 24
bbbb ... = 14
cccc ... = 9
etc

Thanks ... Kha

Follow-Ups:
- Re: SUMIF? Or other?
  - From: Ken

Prev by Date: Re: Excel *** for ”multi emailing”???
Next by Date: Re: sumif with 3 condition
Previous by thread: Re: Excel *** for ”multi emailing”???
Next by thread: Re: SUMIF? Or other?
Index(es):
- Date
- Thread