Results 1 to 9 of 9

Sumifs criteria range with row and column

Threaded View

  1. 05-01-2017, 01:54 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
    Attached Files Attached Files
    Last edited by 6StringJazzer; 05-01-2017 at 02:07 PM. Reason: added attachment
    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. How to sum SUMIFS - multiple criteria for one criteria range???
    By trstew in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-06-2016, 02:37 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