adding values if the same - SUMIF in range of cells?

[Eisaz]

hiya, i have a small project and i've spent too much time on this already -
can't figure it out myself. What i need to do is to create a formula which
will find the same values in column A and will sum the corresponding to them
values from columns B:E.
this is a sort of result i want to get:
A B C D E F RESULT:
1 A1 1 5 2 3 A1 31
2 B5 2 6 3 3 A2 19
3 C1 3 7 4 3 B1 22
4 A1 4 8 5 3 B5 37
5 B5 5 9 6 3 C1 33
6 C2 6 1 6 3 C2 16
7 A2 7 2 7 3
8 B1 8 3 8 3
9 C1 9 4 0 3

I would appreciate any ideas how to do this. Thanks and regards,

 

[T. Valko]

Try this:

=SUMPRODUCT((A$1:A$9=F1)*B$1:E$9)

Copy down as needed

 

[Sheeloo]

One way is to
Enter in F1
=Sum(b1:e1)

Then in H1 in the result area (assuming in Col G & H)
=sumproduct(--(A1:A100=G1),(F1:F100))
Change 100 to the last row in your dataset.

 

[Eisaz]

thank you for such a quick response - going to try it now and let you know
how it goes


thanks again
S

 

[Max]

1. Ah, so you multi-posted in .newusers as well. That's not good, pl refrain.
2. You should reply to each and every response that you receive, whether
here or in .newusers. Please see to this. And don't forget to rate each and
every response by pressing the Yes buttons therein from where you reading
this, in MS' webpages.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---