formulae to look at 52 sheets &count if 2 cells have data entered
 

Hi All

Been a busy boy today, on excel. Im wondering if any one could assist
me in this formuleas I am struggling with?

Ok here it goes...

I would like the formulae to look at 52 sheets, specifically 2 cells
within the sheet, if they have dates entered into them, return a 1.

E.g.

Sheet 1

Cells N12&012 have dates in them = 1

sheet 2

Cells N12 has a date in it but o12 has not return = 0

etc etc

Hope this makes sense

Your help would be much appreciated.

Thanks

Andrew


--
bsnapool
------------------------------------------------------------------------
bsnapool's Profile: http://www.excelforum.com/member.php...o&userid=36115
View this thread: http://www.excelforum.com/showthread...hreadid=559920

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