Excel IIF statement 1

[raven39]

I have an excel workbook that i would like to make an IIF statement in. I have a running total that i need to subtract the closed accounts amounts from.

cell J9 = sum(f4:f999)
cell h4:h999 = "X" <trigger for IIF statement to subtract a closed account amount>

Can anyone help me with the iif statement needed for this?

thanks raven

 

[mbarron]

The following will give you the negative value of all numbers in the F column that have an X in the corresponding H column

=SUMPRODUCT((F4:F999)*(H4:H999="x")*-1)

This one will give you a total of all of the values in the F column that do not have an X in the H coulmn
=SUMPRODUCT((F4:F999)*(H4:H999<>"x")*1)



Mike

 

[raven39]

Mike

That works great!!! Thank you!

Raven