MrExcel Publishing
Your One Stop for Excel Tips & Solutions

COUNTIF


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 :-

=COUNTIF(Sheet1!A1:A5,1)+COUNTIF(Sheet2!A1:A5,1)