Guide Me

Hello,

I have 12 worksheets (jan to Dec), and i want to count the customer name repeated from jan to dec. for every month i will open on sheets and enter data. Now i want the result (counting the customer name from jan to dec) in another excel sheet of same workbook.

I tried the following formula.

=+SUMPRODUCT(COUNTIF(INDIRECT("Sheet"&{1,2,3,4}&"!F1:F200"),"SYED"))

It works but when i add sheet 5, it doesn't work. so we have to update formula like this

+SUMPRODUCT(COUNTIF(INDIRECT("Sheet"&{1,2,3,4,5}&"!F1:F200"),"SYED"))

for every time we can not do this, can u pls help.

Regards
David