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
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