Sumifs with multiple Criteria (1 Viewer)

PNGBill

Win10 Office Pro 2016
Local time
Tomorrow, 01:29
Joined
Jul 15, 2008
Messages
2,271
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
Local time
Tomorrow, 01:29
Joined
Jul 15, 2008
Messages
2,271
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

Top Bottom