Alan McQuaid via OfficeKB.com
Guest
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)"
This should return your values
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
Bookmarks