+ Reply to Thread
Results 1 to 3 of 3

Sum multiple sheets with criteria

Hybrid View

  1. #1
    Registered User
    Join Date
    01-08-2014
    Location
    Somonauk, IL
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Sum multiple sheets with criteria

    Thank you Ford for the response, I got lost at the range name and how to use that. I attached a sample workbook - In the summary sheet, I want to add b4 thru 8-24 to 8-26 if d4 in that sheet =3 and e4 in that sheet =22.5. So even more simply, if in sheet 8-24 d4=3 and e4=22.5 then it would add that value, then the same for 8-25 and 8-26.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple cells, multiple sheets, multiple criteria matching
    By Drudnits1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-17-2014, 12:12 PM
  2. [SOLVED] Search for multiple rows from multiple sheets by criteria & show result in userform
    By ANDREAAS in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-07-2014, 11:29 AM
  3. [SOLVED] Two criteria Index Match on multiple sheets returning multiple values
    By Joak in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-21-2014, 10:03 AM
  4. [SOLVED] Lookup and sum multiple values based on a single criteria in multiple sheets.
    By paulsanett in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2014, 12:18 PM
  5. Replies: 2
    Last Post: 09-19-2013, 04:22 AM
  6. [SOLVED] Counting multiple items with multiple criteria from multiple sheets?
    By essee in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-23-2013, 01:56 AM
  7. Replies: 0
    Last Post: 07-27-2011, 01:00 AM

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