Forum Discussion
GT1704
Sep 27, 2021Copper Contributor
sumif and date range
Hi, I was wondering if someone can help me with a Sumif and date range formula? I wanted to add invoices for two date ranges for one client. I've attached a file with some data in it that explains...
- Sep 27, 2021
GT1704 Perhaps the attached file will work for you. I've used SUMPRODUCT in stead of SUMIF.
Riny_van_Eekelen
Sep 27, 2021Platinum Contributor
GT1704 Perhaps the attached file will work for you. I've used SUMPRODUCT in stead of SUMIF.
- GT1704Sep 27, 2021Copper ContributorThank you Riny_van_Eekelen!
This works very well. I have not used SUMPRODUCT before and this is an excellent alternative.
Cheers