• 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.

SUMIF multiple sheets with multiple criteria

Kristine Pacia

New Member
Help!

How to sum Sheets 1 and 2 (column K) entries in monthly summary sheet (D11) given the ff criterias:
1. The name of Employee in Sheet 1 and 2 (column A) is equals to the name in monthly summary sheet (A11)
2. Date of the 1 and 2 sheet (B3) is equals to the date in monthly summary sheet (D9)

Thank you!
 

Attachments

  • Schedule Template V3.xlsx
    107.2 KB · Views: 8
Try,

In "Monthly Summary" Sheet D11, formula copied across and down :

=IFERROR(1/(1/SUMPRODUCT((INDIRECT("'"&DAY(D$9)&"'!$A7:$A174")=$A11)*INDIRECT("'"&DAY(D$9)&"'!$K7:$K174"))),"")

Regards
Bosco
 
Back
Top