Hi,

Thanks for that, Currently getting the end result by using the COUNTIF on each sheet for each 'if' and then using SUM(Start:Spacer!A1) to bring back my total, this works great but unfortuneately there are over 123 sheets each with 336 COUNTIF formula's - thus making the workbook rather large (without user data!) and prone to freezing upon open.

Unfortuneatley I also add, change and delete worksheets regulary, so it would seems the SUMPRODUCT approach is also not the solution and as the workbook is used on the network by users at different workstations I guess the morefunc.xll is a no go either!

I may just have to admit defeat?

Wil