How to add the sum of cells in column 2 based on column 1

[Godmode]

Hi,

I dont know what to search for with this question.

I want to add some cells in column 2 based off of level numbers in column 1.

Example:

Level	Upgrade cost
	Metal
1	400
2	800
3	1,600
4	3,200
5	6,400
6	12,800
7	25,600
8	51,200

<colgroup><col style="width: 55px"><col width="83"></colgroup><tbody>
</tbody>

If I want to add up the sum for numbers that correspond to level 4-8 in the Metals column based on my level being 3, how would I do this?

 

[Peter_SSs]

Welcome to the MrExcel board!

It isn't entirely clear to me as you didn't state the expected result but is this what you mean?

Excel Workbook
	A	B	C	D	E
1	Level	Upgrade cost		My Level	3
2		Metal		Upgrade Cost	99200
3	1	400
4	2	800
5	3	1,600
6	4	3,200
7	5	6,400
8	6	12,800
9	7	25,600
10	8	51,200
11
SUMIF

 

[Godmode]

That is exactly what I needed. Thanks for your help.

 

[Peter_SSs]

That is exactly what I needed. Thanks for your help.

No problem. Thanks for letting us know.