Results 1 to 4 of 4

Thread: Match and CountIF Across Multiple Sheets Using Formula

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 03-09-2013, 08:22 PM #1
    khateeb
    khateeb is offline
    Junior Member
    Join Date
    Mar 2013
    Posts
    2
    Rep Power
    0

    Match and CountIF Across Multiple Sheets Using Formula

    I need assistance, please provide a sample working formula... this is the range of sheets described as date [Data validation]... E3: E33... my range is E3:E14 for all the sheets (that is Date1 --E3 to Date31 E33..])... matching up for I3: I14 for MF8330 and summing up in summary2...Please check the attachment.

    MF8330 black compare and add from all sheets for only building 1.1.1
    MF8330 Cyan Compare and add from all sheets for only building 1.1.1
    Similarly for other2 colors.

    Please check the attachment.
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Combine Columns From Multiple Sheets To One Sheet
    By Portucale in forum Excel Help
    Replies: 6
    Last Post: 04-24-2013, 09:18 PM
  2. Lookup On Multiple Columns And Return Result Using Match Index
    By nikhil83 in forum Excel Help
    Replies: 4
    Last Post: 04-24-2013, 10:04 AM
  3. Lookup All Corresponding Values Match Criteria In Adjacent Column Array Formula
    By d380013 in forum Excel Help
    Replies: 16
    Last Post: 04-19-2013, 08:20 PM
  4. Lookup Data From Multiple Sheets To Single Sheet Consolidated View Using Formula
    By Redwhite in forum Excel Help
    Replies: 2
    Last Post: 03-21-2013, 10:38 PM
  5. Vlookup - Multiple Sheets
    By Suhail in forum Excel Help
    Replies: 3
    Last Post: 01-30-2013, 06:47 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