View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
NC NC is offline
external usenet poster
 
Posts: 7
Default Sumif Help needed

As already specified in message pressing "Shift+control+enter" after
entering formula makes it be treated as array formula

for more on array formulas visit following url

http://www.cpearson.com/excel/array.htm

Regards
NC