Microsoft Excel help needed. Basically i got a table like this (fairly simplified for this purpose):
1 12.2
1 15.6
2 14.5
2 34.5
3 34.7
4 1.9
And im trying to get a formula that will add up the sum of all the rows corresponding to 2 (14.5 + 34.5). If i use VLookup(2;A1:B6;2;FALSE), it just retrieves the value the first time it encounters 2, 14.5 in the above example. Is there a way to make all the values corresponding to 2 add up. I hope this makes sense.
|