First off, remove the space from the first tab. It will make you equations more aesthetic. Doing so and making it so the equation is copyable results in:
=SUMIFS(AllData!$C:$C,AllData!$A:$A,$A6,AllData!$B :$B, ">=" &C$5,AllData!$B:$B,"<" & D$5)
I added some more date headers as the equations in Column E, for example, refer to the date header in Column F.
|