# Conditional sum total formula

• Using the following example:

(A)***(B)****(C)***(D)***(E)**(F)***(G)
TITLE -- FINE - QTY - NMT -QTY -MINT - QTY
Mantle - 20.00 - 1 - 35.00 - 0 - 50.00 - 1
Mays --- 30.00 - 0 - 45.00 - 1 - 65.00 - 0
Ruth --- 40.00 - 0 - 55.00 - 1 - 85.00 - 1

Column H (not pictured) would total the values for Column B,D and F - IF - there was a quantity of 1 or greater in corresponding rows C,E and G.

Can anybody help? I don't normally use Excel, but my supervisor has requested this info in an Excel file.
Thanks in advance for any help!

Blake

• Re: Conditional sum total formula

why note

H = (B*C) + (D*E) + (F*G)

if C, E or G = 0 then sum of that section will also = 0

• Re: Conditional sum total formula

Try these

=SUMIF(C2:C4,1,B2:B4)
=SUMIF(E2:E4,1,D2:D4)
=SUMIF(G2:G4,1,F2:F4)

Boo!:yikes:

• Re: Conditional sum total formula

Thanks so much - Have a Great Day!

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!