This worked - thanks! Not that I am asking anyone to look at this further, but I am still frustrated that the WEEKDAY function behaves so badly within the COUNTIFS and SUMPRODUCT formulas. The initial suggestion using SUMPRODUCT did not give the correct answer, I had been trying many different approaches to get SUMPRODUCT or COUNTIFS to work using WEEKDAYS as criteria.