Results 1 to 2 of 2

Macros requiring a nested IF AND formula?

Threaded View

  1. 09-23-2016, 01:08 AM #1
    heidi78
    heidi78 is offline
    Registered User
    Join Date
    03-02-2015
    Location
    Brisbane, Australia
    MS-Off Ver
    2012
    Posts
    4

    Macros requiring a nested IF AND formula?

    Hi I am trying to summarise data from several sheets into one summary page. however the data being drawn is not always appearing in the same cell between worksheets. so I assume there is to be nested formulas. I have no idea how to achieve this summary. I have attached an example of the two worksheets, highlighting the data I want to summarise with a macro button. can anyone please help with this complex formula?
    thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula help requiring two variables
    By isimba in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-10-2012, 08:27 AM
  2. FORMULA Requiring Multiple Actions
    By mistytreasure in forum Excel General
    Replies: 3
    Last Post: 05-31-2011, 11:38 AM
  3. Formula requiring three actions
    By rraymond in forum Excel General
    Replies: 7
    Last Post: 05-27-2011, 04:50 PM
  4. [SOLVED] using sumif formula: but requiring satisfying 2 if statements
    By Bernard Liengme in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 12:05 PM
  5. using sumif formula: but requiring satisfying 2 if statements
    By Bernard Liengme in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  6. [SOLVED] using sumif formula: but requiring satisfying 2 if statements
    By karenm in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  7. using sumif formula: but requiring satisfying 2 if statements
    By karenm in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  8. [SOLVED] Formula requiring two different criterias
    By MJMP in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-01-2005, 07:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1