Thread: SUMIF finds data when Criteria is blank
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
emea training 2
 
Posts: n/a
Default SUMIF finds data when Criteria is blank

When using the SUMIF formula and referencing the Criteria to a blank
cell, a result is still returned? I would have thought that it would
have given me an N/A or REF

However, this value is not in the Sum Range - does anyone know what it
is?




--
emea training 2
------------------------------------------------------------------------
emea training 2's Profile: http://www.excelforum.com/member.php...o&userid=12102
View this thread: http://www.excelforum.com/showthread...hreadid=551939

Reply With QuoteReply With Quote