Is there a way to Sumifs up to a certain column with multiple criteria?

Hi everyone,

I’m looking for a formula to sum all of the columns starting from a particular column up to a particular column. How do I best do that?

On the data tab, Row 1 I have the following columns:

A1 = date

B1 = serial number

C1 = customer name

D1 = date 1, with the data being $

E1 = date 2, with the data being $

F1 = date 3, with the data being $

In a separate tab I have the same thing mirroring the data tab, but without the $, for the calculation what I intend to do is on E2, I want to say if $A2 = E$

1, then sum all of D up to E column on the data tab provided that the value on B column of the data tab match B2 of the calc tab, and C column of the data tab match C2 of the calc tab.

For F2, it would be the same thing, but sum column D up to column F instead of column E.

I hope it makes sense. Thanks for your help!