=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.

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


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=534004

Hi!

Try this:

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

Biff

"EBronco67" wrote in message
...
=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.

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.

"EBronco67" wrote:

=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.