Results 1 to 6 of 6

Match values in 2 columns and return the sum

Threaded View

  1. #1
    Registered User
    Join Date
    12-05-2011
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    15

    Match values in 2 columns and return the sum

    Hi,

    I would appreciate some assistance with the following.

    I have a spreadhseet with multiple tabs, I need to checj a tab and match data in 2 columns and then the result should appear as a count in another tab. For example, in cell I3 in tab 'Productivity Table', I want there to be a formula that checks tab 'Co-Leading & Scoping' and identifies if Column C = 'Adam B' and if column A does not equal 'FY12'. If so, the total number of occurences should be output to the tab 'Productivity Table' in cell I3.

    Similarly in cell J3 on the tab 'Productivity Table', I again want to check the tab 'Co-Leading & Scoping', but this time check for 'Adam S' in column C and 'FY12' in colum A.

    Please see spreadsheet attached to see the data I am referring to above.

    If you are able to demonstrate the answer with a working example, that would be great.

    Thanks!
    shaz_79
    Attached Files Attached Files

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