Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum If
A B C D E Div GLEntry GL# Div Div Total 1 $(7,954.07) 1 -$1934.64 1 $(1,342.00) 1 02 $4400.00 1 $ (592.54) 1 03 -$1198.35 1 $(4,629.00) 04 $-.10 02 $5000.00 1 02 $ (600.00) 1 02 $ 77.77 03 $ 19.00 03 $ 694.05 1 03 $ 100.91 03 $ (13.00) 03 $(1,892.40) 1 04 $(2,588.56) 04 $ (0.10) 1 What I would like to do: If Col A =1 and Col C=1 then I would like for it to sum the amounts from Col B in the Corresponding Div in Col E (as per my totals in Col E). Thank you very much for any help you can give me. Donna |