Dont include in sum if cell contains this value
 

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: http://www.excelforum.com/attachment.php?postid=4680 |
+-------------------------------------------------------------------+

--
exutable
------------------------------------------------------------------------
exutable's Profile: http://www.excelforum.com/member.php...o&userid=28665
View this thread: http://www.excelforum.com/showthread...hreadid=535290

Dont include in sum if cell contains this value
 

Try this:

=SUMIF(B2:B4,"<no sum",A2:A4)
--
HTH,

RD

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

"exutable" wrote in
message ...

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: http://www.excelforum.com/attachment.php?postid=4680 |
+-------------------------------------------------------------------+

--
exutable
------------------------------------------------------------------------
exutable's Profile:
http://www.excelforum.com/member.php...o&userid=28665
View this thread: http://www.excelforum.com/showthread...hreadid=535290

Dont include in sum if cell contains this value
 

Sorry comes out as three.....


--
exutable
------------------------------------------------------------------------
exutable's Profile: http://www.excelforum.com/member.php...o&userid=28665
View this thread: http://www.excelforum.com/showthread...hreadid=535290

Dont include in sum if cell contains this value
 

I placed a <space between "no" and "sum".

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"exutable" wrote in
message ...

Sorry comes out as three.....


--
exutable
------------------------------------------------------------------------
exutable's Profile:
http://www.excelforum.com/member.php...o&userid=28665
View this thread: http://www.excelforum.com/showthread...hreadid=535290