Results 1 to 2 of 2

SUMIFS using many rows and many coulmns

Threaded View

  1. #1
    Registered User
    Join Date
    11-21-2011
    Location
    xyz
    MS-Off Ver
    Excel 2003
    Posts
    1

    SUMIFS using many rows and many coulmns

    SUMIFS using many rows and many coulmns
    Hi Expert,

    I have table and i need to sum the value with criteria from rows and cloumn
    the data such like below :

    sumifs.xlsx

    criteria 1 A
    criteria 2 Y
    criteria 3 P

    formula sumif but can not work
    =SUMIFS(B3:C7,B1:C1,B11,B2:C2,B12,A3:A7,A13)

    the i want to sum the value base on all 3 criteria, as i know it using "sumifs" but can't not work / error

    i need your advice and suggestion please.

    thanks in advance

    Regards,
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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