• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

SumIFS w/ Index Match - Horizontal and Vertical

H

Hunter Childress

Member
Please see the attached example. On the output tab, I am tying to sum by type (column) and by month(row). I can't get it to work.
 

Attachments

  • Example.xlsx
    63.8 KB · Views: 16
Try in B2:
Code: 
=SUM(FILTER(FILTER(Sheet1!$B$3:$HW$71,Sheet1!$B$1:$HW$1=B$1),Sheet1!$A$3:$A$71=$A2))
copy down/across.

(Power Query could do this too.)
 
Please try

=MMULT(MMULT(N(TOROW(Sheet1!A3:A71)=A2:A4),Sheet1!B3:HW71),N(TOCOL(Sheet1!B1:HW1)=B1:K1))
 

Attachments

  • Example.xlsx
    64.9 KB · Views: 18
You must log in or register to reply here.
Back
Top