Thread: formulae to look at 52 sheets &count if 2 cells have data entered
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
mrice mrice is offline
external usenet poster
  
Posts: 1
Default formulae to look at 52 sheets &count if 2 cells have data entered

I'm assume that the cells that you want to test will either contain a
date of be blank. If so, a formula like the following will work.

=IF(AND(Sheet1!N12 <"",Sheet1!O12 <""),1,0)


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=559920

Reply With QuoteReply With Quote