MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Andy on January 03, 2002 1:34 PM

Is it possible to specify a range for countif which spans over many worksheets? When I try to do it, Excel gives me the error message - #VALUE!.

What am I doing wrong?

Please help!

Posted by Faulconbridge on January 03, 2002 5:07 PM

One way is like this :-