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