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

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,

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" wrote:

> 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,
>