simplify equation

[Guest]

=IF(F5="X",+(J5),-(J5))+IF(F6="X",+(J6),-(J6))+IF(F7="X",+(J7),-(J7))+IF(F8="X",+(J8),-(J8))...

all i want is if i put an "X" in a the cell i want it to either add the
number in the other cell. if i don't i want it to subtract the number in the
other cell. but i don't want to have to do the busy work of typing it over
and over only changing what row its in.

 

[John James]

=sumproduct(--(f5:f100="x"),j5:j100)-sumproduct(--(f5:f100<>"x"),j5:j100

 

[Biff]

Hi!

Try this:

=SUMIF(F5:F8,"x",J5:J8)-SUMIF(F5:F8,"",J5:J8)

Biff

 

[Guest]

Thank You! Both of your equations worked. I sat here for 45 mins. trying to
figure it out before i tried this site. I guess I'll chalk that one up to a
long lesson.