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