software

Hey I am currently working on something, take a look
I want it to be like this: If B3=nosum then A3 is not included in the
sum at the bottom, take a look at the picture

Thanks guys!

4680 -------------------------------------------------------------------
|Filename: sum.jpg |
|Download: www.excelforum.com/attachment.php?postid=4680 |
-------------------------------------------------------------------

--
exutable
------------------------------------------------------------------------
exutable's Profile: www.excelforum.com/member.php...oamp;userid=28665
View this thread: www.excelforum.com/showthread...hreadid=535290Try this:

=SUMIF(B2:B4,quot;lt;gt;no sumquot;,A2:A4)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

quot;exutablequot; gt; wrote in
message ...
gt;
gt; Hey I am currently working on something, take a look
gt; I want it to be like this: If B3=nosum then A3 is not included in the
gt; sum at the bottom, take a look at the picture
gt;
gt; Thanks guys!
gt;
gt; 4680
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: sum.jpg |
gt; |Download: www.excelforum.com/attachment.php?postid=4680 |
gt; -------------------------------------------------------------------
gt;
gt; --
gt; exutable
gt; ------------------------------------------------------------------------
gt; exutable's Profile:
www.excelforum.com/member.php...oamp;userid=28665
gt; View this thread: www.excelforum.com/showthread...hreadid=535290
gt;
Sorry comes out as three.....--
exutable
------------------------------------------------------------------------
exutable's Profile: www.excelforum.com/member.php...oamp;userid=28665
View this thread: www.excelforum.com/showthread...hreadid=535290I placed a lt;spacegt; between quot;noquot; and quot;sumquot;.

Change the formula or your data to match each other.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;exutablequot; gt; wrote in
message ...
gt;
gt; Sorry comes out as three.....
gt;
gt;
gt; --
gt; exutable
gt; ------------------------------------------------------------------------
gt; exutable's Profile:
www.excelforum.com/member.php...oamp;userid=28665
gt; View this thread: www.excelforum.com/showthread...hreadid=535290
gt;