Results 1 to 2 of 2

Sumifs criteria range with row and column

Threaded View

  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
« 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