View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
exutable
 
Posts: n/a
Default 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