I currently use this formula:
=SUMPRODUCT(--($S$10:$S$60001=$H$2);$H$10:$H$60001)/$T$4
My ColS values are dates that look like so:
20050512 (year,month,day).
I would like to modify the formula to sum only if the 5th and 6th character
= 05.
Thank you in advance.
Bookmarks