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

  • Thread starter Thread starter bsnapool
  • Start date Start date
B

bsnapool

Hi All

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

Ok here it goes...

I would like the formulae to look at 52 sheets, specifically 2 cell
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

Andre
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formulae to look at 52 sheets &count if 2 cells have data entered 1
min,average>0 if 52 cells read zero 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
make formula look at diff sheet 5
naming a sheet the same as a cell in that sheet 3
Summing up various Worksheets to one Summary sheet using variables 1
what would the script look like to open a new sheet 1
Copy formula from various sheets 2

Back
Top