View Single Post
Old 09-19-2019, 06:09 PM   #2
PNGBill
Win10 Office Pro 2016
 
Join Date: Jul 2008
Location: Tokoroa, New Zealand
Posts: 2,269
Thanks: 74
Thanked 78 Times in 74 Posts
PNGBill will become famous soon enough
Re: Sumifs with multiple Criteria

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.
PNGBill is offline   Reply With Quote