simplify equation

[EBronco67]

=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

"EBronco67" <[email protected]> wrote in message
news:[email protected]...
> =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.

[EBronco67]

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.