Good afternoon,
I'm trying to get this code to work but I'm returning no results, can anyone help
I know there is a payment made on 04/08/2016 but my code is showing as zero results, is it the format of the date or something else?
Thanks=SUMPRODUCT(((Table_Query_from_csolve[DebtorId]=Sheet3!A8527)*(Table_Query_from_csolve[DatePaymentMade]>"31/12/2015")*(Table_Query_from_csolve[DatePaymentMade]<="31/08/2016")*(Table_Query_from_csolve[Counter])))
Bookmarks