SUMIF Problem

  • Thread starter Thread starter Joe Gieder
  • Start date Start date
J

Joe Gieder

I have this formula:
=SUM(IF(('Priced BOM'!$G$3:$G$878,"No",'Priced BOM'!
$AC$3:$AC$878-SUM('Priced BOM'!$AD$3:$AD$878))/2))+SUM
('Priced BOM'!$AD$3:$AD$878)+SUM('Priced BOM'!
$AE$3:$AE$878),0)

The total values I'm working with are:

AC3:AC878 = $773,162.84
AD3:AD878 = $18,464.76
AE3:AE878 = $35,605.00

I'm trying to subtract the value of AD from the value of
AC then divide that total by 2 then add the SUM of AD &
AE back into the new value of AC
Values should be:
AC ($377349.04) + AD ($18,464.76) +AE ($35,464.76)
and the answer should be $431,418.80

As always thank you all for the help.

Joe
 
I figured it out.

=SUM(SUMIF('Priced BOM'!$G$3:$G$878,"No",'Priced BOM'!
$AC$3:$AC$878)-SUM('Priced BOM'!$AD$3:$AD$878),0)/2+SUM
('Priced BOM'!$AD$3:$AE$878)

Thanks for the help. There may be a better way to write
this but it works out.

Joe
 
Back
Top