software

=IF(F5=quot;Xquot;, (J5),-(J5)) IF(F6=quot;Xquot;, (J6),-(J6)) IF(F7=quot;Xquot;, (J7),-(J7)) IF(F8=quot;Xquot;, (J8),-(J8))...

all i want is if i put an quot;Xquot; 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=quot;xquot;),j5:j100)-sumproduct(--(f5:f100lt;gt;quot;xquot;),j5:j100)--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=534004Hi!

Try this:

=SUMIF(F5:F8,quot;xquot;,J5:J8)-SUMIF(F5:F8,quot;quot;,J5:J8)

Biff

quot;EBronco67quot; gt; wrote in message
...
gt; =IF(F5=quot;Xquot;, (J5),-(J5)) IF(F6=quot;Xquot;, (J6),-(J6)) IF(F7=quot;Xquot;, (J7),-(J7)) IF(F8=quot;Xquot;, (J8),-(J8))...
gt;
gt; all i want is if i put an quot;Xquot; in a the cell i want it to either add the
gt; number in the other cell. if i don't i want it to subtract the number in
gt; the
gt; other cell. but i don't want to have to do the busy work of typing it over
gt; 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.

quot;EBronco67quot; wrote:

gt; =IF(F5=quot;Xquot;, (J5),-(J5)) IF(F6=quot;Xquot;, (J6),-(J6)) IF(F7=quot;Xquot;, (J7),-(J7)) IF(F8=quot;Xquot;, (J8),-(J8))...
gt;
gt; all i want is if i put an quot;Xquot; in a the cell i want it to either add the
gt; number in the other cell. if i don't i want it to subtract the number in the
gt; other cell. but i don't want to have to do the busy work of typing it over
gt; and over only changing what row its in.