Hi Forum,
This Sumfs sums the sales amounts in Sheet Data Col D where customer name Sheet Data Col F matches with current sheet (Customers A7 - Works well.
This Sumfs is similar but sums all the sales amounts for 2019. Sheet Data Col B has date.
How can I combine these two to get Sales for a Customer by date range ? :banghead:
I tried combining them
No result. Not even an error message
This Sumfs sums the sales amounts in Sheet Data Col D where customer name Sheet Data Col F matches with current sheet (Customers A7 - Works well.
Code:
=SUMIFS(Data!$D$7:$D$150000,Data!$F$7:$F$150000, Customers!A7)
This Sumfs is similar but sums all the sales amounts for 2019. Sheet Data Col B has date.
Code:
=SUMIFS(Data!$D$7:$D$150000,Data!$B$7:$B$150000,">=01/01/2019",Data!$B$7:$B$150000, "<=31/12/2019")
How can I combine these two to get Sales for a Customer by date range ? :banghead:
I tried combining them
Code:
=SUMIFS(Data!$D$7:$D$150000,Data!$B$7:$B$150000,"=Year(2018)",Data!$F$7:$F$150000, Customers!A6)
No result. Not even an error message
Last edited: