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

1. ## 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

2. ## Re: formulae to look at 52 sheets &count if 2 cells have data entered

Andre,

Why not try the following formula

"=if(AND(N12>0,O12>0),1,0)"

Alan

>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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200607/1

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1