How to sum specific cells if dates match?

[caaronh85]

Hello everyone, I am hoping to get some help with a progress report I'm working on. I have 2 sheets, 'HB Repairs' which holds repair data in a table along with a date for when the repair was made. The other sheet 'Repair Metrics' shows 5 days of dates with a column of repairs. What I would like to have happen is when a date is selected on the 'Repair Metrics' sheet, the repairs for those specific dates are populated into the 'Repair Metrics' sheet, if that makes sense. Is this possible with a native formula? I've tried VLOOKUP but it isn't counting the specific repairs and then adding them.

 

[mrshl9898]

Like this?

=SUMIFS('HB Repairs'!$D:$D,'HB Repairs'!$C:$C,$A4,'HB Repairs'!$I:$I,B$3)+SUMIFS('HB Repairs'!$F:$F,'HB Repairs'!$E:$E,$A4,'HB Repairs'!$I:$I,B$3)+SUMIFS('HB Repairs'!$H:$H,'HB Repairs'!$G:$G,$A4,'HB Repairs'!$I:$I,B$3)

 

[caaronh85]

Like this?

=SUMIFS('HB Repairs'!$D:$D,'HB Repairs'!$C:$C,$A4,'HB Repairs'!$I:$I,B$3)+SUMIFS('HB Repairs'!$F:$F,'HB Repairs'!$E:$E,$A4,'HB Repairs'!$I:$I,B$3)+SUMIFS('HB Repairs'!$H:$H,'HB Repairs'!$G:$G,$A4,'HB Repairs'!$I:$I,B$3)

I tried this and it put zeros in all the cells on 'Repair Metrics' sheet. Also, changing the dates did not change cell data either. I think you're on the right track because the formulas I tried gave me Value and NA errors so at least now I'm getting some number. Any other ideas?

 

[caaronh85]

Like this?

=SUMIFS('HB Repairs'!$D:$D,'HB Repairs'!$C:$C,$A4,'HB Repairs'!$I:$I,B$3)+SUMIFS('HB Repairs'!$F:$F,'HB Repairs'!$E:$E,$A4,'HB Repairs'!$I:$I,B$3)+SUMIFS('HB Repairs'!$H:$H,'HB Repairs'!$G:$G,$A4,'HB Repairs'!$I:$I,B$3)

Nvm, I had some cells swapped. This is what I needed. Thank you and I have marked your answer as a solution.