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