If statement

[dchaney]

I currently have a spreadsheet that looks at Cell B3 if B3 = Engineering then add cells C3 through G3 **=IF($B3="Engineering",SUM($C3:$G3),"")**

I am trying to figure out how to look at B3:B36, for any cell in that range that = Engineering I want it to add the amounts in C?

I tried =IF($B3:$B36="Engineering",SUM($C3:$G3),"")

Example: The formula would return 5 for the below

Engineering 3
Purchasing 2
Engineering 2

 

[Boller]

Use SUMIF

 

[hiker95]

dchaney,

Excel Workbook
	B	C	D	E
3	Engineering	3		5
4	Purchasing	2
5	Engineering	2
6
Sheet1

 

[dchaney]

Thank you all, I knoiw I was missing something easy

 

[snoopyhr]

Two more alternative,
Just in case interested

Excel Workbook
	A	B	C	D	E
1	Engineering	3		5	CTRL Shift Enter
2	Purchasing	2		5	Just Enter
3	Engineering	2
Sheet1