SUMIFS Formula...only if that row contains certain text

[sfscottca]

Component SERIAL Project Name Component Cost Total Cost
Wheels 00072 Custom Bike 007 $3,150.76 (blank)
Frame 00073 Custom Bike 007 $680.92 $3,831.68

I used the following formula to calculate project cost:
=SUMIF(C:C, C3, D:D)

I only want the Total Cost populated if Component="Frame".
I cannot figure out how do to this with SUMIFS or other excel formulas

 

[Marcelo Branco]

Not sure if i understand what you need. Couldn't simply use this

=IF(A2="Frame",SUMIF(C:C,C2,D:D),"")

M.

 

[shobolos]

Excel 2012
	A	B	C	D	E	F	G
1	Component	SERIAL	Project	Name	Component	Cost	Total Cost
2	Wheels	72	Custom	Bike	7	$ 3,150.76
3	Frame	73	Custom	Bike	7	£ 680.92	3831.68
Sheet1

Cell Formulas
Range	Formula
G2	=IF(A2="Frame",SUMIFS(F:F,E:E,7),"")

 

[sfscottca]

shobolos and Marcelo - formulas look great!

=IF(A2="Frame",SUMIF(C:C,C2,D:D),"")

How can I modify to include all component names with Frame...like "Carbon Frame" and "Aluminum Frame"
(A2="*Frame" doesn't work for me)

Thanks!

 

[Marcelo Branco]

Maybe

=IF(ISNUMBER(SEARCH("Frame",A2)),SUMIF(C:C,C2,D:D),"")

M.

 

[sfscottca]

Perfect

Thanks so much for the quick reply!

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.