Closed Thread
Results 1 to 2 of 2

Sumifs criteria range with row and column

  1. 05-01-2017, 01:58 PM #1
    silambarasan.J
    silambarasan.J is offline
    Forum Contributor
    Join Date
    08-07-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    372

    Sumifs criteria range with row and column

    Dear Forum Leader,

    Sheet 1Time Sheet)

    Row Range : A2:A378- Date

    Column Range: B1:J1- Names

    Column Range: B2:J378- Working hours

    Sheet 2 : (Payslip)

    How do sumifs one sheet to another sheet when criteria ranges meet both of column and row

    Sample workbook attached. please help me.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-01-2017, 02:05 PM #2
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Sumifs criteria range with row and column

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
Closed Thread
« 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. A sumifs forumla with multiple criteria in the criteria range
    By bellablu in forum Excel General
    Replies: 3
    Last Post: 02-02-2017, 04:32 AM
  2. [SOLVED] SUMIFS with multiple criteria WITH specified dynamic range criteria
    By dluhut in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-20-2017, 11:03 AM
  3. Sumifs - two criteria where one criteria is to match anything in a range
    By FHen in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-15-2016, 07:37 PM
  4. SUMIFS with vertical criteria and horizontal criteria (horiz. crit. is a date range check)
    By STUARTXL in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-03-2016, 03:39 AM
  5. SUMIFS: Cannot use the same criteria range (A column)
    By cssst5 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-23-2013, 04:05 PM
  6. SUMIFS with 1 criteria range, multiple criteria with cell references
    By heatherromo in forum Excel General
    Replies: 3
    Last Post: 11-21-2012, 04:57 PM
  7. Excel 2007 : Sumifs formula lookup multiple criteria in criteria range
    By matthews311 in forum Excel General
    Replies: 1
    Last Post: 05-16-2011, 05:00 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