+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Registered User
    Join Date
    07-06-2006
    Posts
    29

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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