At 17:19 24/08/2018 +0200, Hylton Conacher wrote:
Formula worked perfectly, ...
... HATS off to you Brian.
Thanks, but hats off to the SUMPRODUCT() function really. My final formula:
=SUMPRODUCT(INT($Data.$A$3:$A$30/100)=$A4,$Data.D$3:D$30) to display it a sheet different to data
You might prefer to enter your dates as real dates, which could be formatted the way you have them using "YYYYMMDD" as the format string. Then you could extract year and month using the YEAR() and MONTH() functions: