S
Sherim315
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
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