Excel 2007 : Help with Excel Formula

[coolbk]

--A | B
1 20 | 20
2 20 | 40
3 20 | 160
4 10 | 30
5 10 | 290
6 10 | 150
7 5 | 115
8 5 | 105
9 5 | 95

my sheet has many more numbers. basically what i want is to add values in B column if the value in A column equals 20. The answer I need after the formula is 220. is this a possibility.
the same way for 10 the answer should be 470 and for 5 the answer should be 315
8 minutes ago - 4 days left to answer.

[dilipandey]

Hi coolbk,

Welcome to the forum.

I have transferred your example in the attached workbook, which is solved as per your requirement.

Cheers

Regards,
DILIPandey

<click on below 'star' if this helps>

[Palmetto]

Have you looked at the SUMIF and SUMIFS functions?
A Pivot Table is also an option.

Please edit your thread title to something that actually describes your need. Suggested title: SUM cells based on criteria
Since this an Excel Help Forum it is unnecessary and redundant to ask for help with a formula or VBA - - just describe your need.