Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif for a range of values | Excel Discussion (Misc queries) | |||
using sumif to sum a range of values | Excel Worksheet Functions | |||
SUMIF not adding a range | Excel Discussion (Misc queries) | |||
Problem adding a range using Sumif function. | Excel Worksheet Functions | |||
adding summed cells in a conditional sumif | Excel Worksheet Functions |