View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
EdMac
 
Posts: n/a
Default count 2 nonblank cells on multiple worksheets


Hi April,

You need to use SUMPRODUCT

Check out www.xldynamic.com/source/xld/SUMPRODUCT.html

I think you will find what you want (and more).

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=533613