Sumifs with multiple Criteria (1 Viewer)

PNGBill

Win10 Office Pro 2016
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.
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 :confused:
 
Last edited:

PNGBill

Win10 Office Pro 2016
This works
Code:
=SUMIFS(Data!$D$7:$D$150000,Data!$B$7:$B$150000,">=01/01/2019",Data!$B$7:$B$150000, "<=31/12/2019",Data!$F$7:$F$150000, Customers!A7)
Not sure why but on this attempt I didn't type the last part of code.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom