The thing is that if those entries were in your original sheet, I think your formula (that you already have there) would give you the correct result. Unless the setup of your workbook is not like your original sample.

I am confused as to why you think that the formula is wrong.

Hi
The NETWORKDAYS formula in the Sumproduct Challenges workbook only works for a single row. I need it to work for a range. For example I need the number of working days in May 2017 where the row in Column A = "Business Support". That's the bit I am struggling with.
Thanks
Tony