View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sherim315 Sherim315 is offline
external usenet poster
 
Posts: 1
Default Sum Total with minus in different cell

New to excel 07. I need a formula that will look at the following:

COL F Row 2, is a zero and the amount is in col G Row 2 the worksheet has
row 2-32 and I'm trying to put this formula in row 33 and I want the sum of
the values that are in Col G rows 2:32 minus any values that have a zero in
Col F Row 2 the other rows in COL F rows 2-32 can range from a zero to a 1.

I hope I explained this I'm fustrated trying to figure it out and its
probably as plain as the nose on my face