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

Sum Total with minus in different cell
 

One way:

=SUMIF(F2:F32,"<0",G2:G32)

In article ,
Sherim315 wrote:

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