Excel Forumula

[Johnatan56]

Excel Formula

Hi,

stuck on an excel problem.

I am trying to get all unique values from a column, and add its corresponding right value as a sum at the end.

So say you had:

     A     B  
1   x     20
2   y     15
3   x     80
4   t     43
5   y    120

The result should be:

     C     D
1   x    100
2   y    135
3   t    43

I haven't really worked with index before in excel, having an issue with checking if left value is unique.

Any solutions/pointers would be appreciated.

 

[satanboy]

Forumula

I think I traced the problem.

 

[Messugga]

Just do a pivot table... group by C, sum D.

 

[MidnightZA]

I recently used something similar. I used the 'sumif' formula

It worked for me since I only used the days of a week and a corresponding number.
So for example my first formula was "sumif([range1];"Monday";[range2]), this will look for the word "Monday" in "range1" and sum the corresponding value in "range2"

 

[Johnatan56]

I recently used something similar. I used the 'sumif' formula

It worked for me since I only used the days of a week and a corresponding number.
So for example my first formula was "sumif([range1];"Monday";[range2]), this will look for the word "Monday" in "range1" and sum the corresponding value in "range2"

Thanks, that what I am currently doing, re-discovering VBA made life a bit easier to customize the formula for all 31 worksheets.
Will add a final sheet summary on the right side based on the values of the sheet.

So:

=SUMIF(Sheet01!W5:W26, B2, Sheet01!X5:X26)

With B2 being the keyword, W5:W26 being the column where the keyword might be mentioned, and the X5:X26 being its right-hand column.

EDIT: Was also thinking of going SUMPRODUCT, but realized that it might be useful to have a daily/sheetly summary as well, should allow for informative graphs.

I think I traced the problem.

Changed the title while writing it, missed a backspace.