Using countif to look at multiple sheets???

I am trying to create a formula that will tell me how often our sales reps are going to specific accounts.

I have a master list of each persons accounts and next to each account name there will be a cell with a formula in it. This formula will look at the cell next to it, "the account name", and then count how many times that name comes up over each months sheet. I was also wondering if I can then get the average over 12 months in the same formula. If not thats ok.

The problem I am having is that I keep getting an error #VALUE!. I had no problem with it looking at only one sheet, but when I do more than one it gives me an error. I think it is the was I am breaking up each sheet. I have tried to do it every way I can think of... ,;) Nothing seems to work.

Here is the formula that I am trying to use. What am I doing wrong?

Please Login or Register  to view this content.

Thanks for your help!
Lukas