Thread: COUNTA Function
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Simon Lloyd[_8_] Simon Lloyd[_8_] is offline
external usenet poster
  
Posts: 1
Default COUNTA Function

You should explore the use of SUMPRODUCT it's a very powerful function
that acts like an array fomula but doesnt need entering with
Ctrl+Shift+Enter.


--
Simon Lloyd

Regards,
Simon Lloyd
'www.thecodecage.com' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=27543

Reply With QuoteReply With Quote