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,

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

Try this:

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

Copy down as needed

--
Biff
Microsoft Excel MVP


"Eisaz" wrote in message
...
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,

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

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,

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

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


thanks again
S

"Sheeloo" wrote:

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,

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

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