Posted to microsoft.public.excel.worksheet.functions

pdberger

external usenet poster

Posts: 258

COUNTIF across worksheets

Good morning --

I'm shooting for a COUNTIF formula that will count text occurances across
multiple worksheets. I can get the formula to work if the data is on the
same worksheet but as soon as I go to multiple ones, it fails and I get a
'#VALUE!' error.

Here's the formula:

=COUNTIF(First:Last!A1,"Y")

Thanks in advance.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
countif from different worksheets	BeefDr	Excel Worksheet Functions	2	July 7th 08 09:53 PM
countif in many worksheets	Rasoul Khoshravan	Excel Worksheet Functions	2	October 22nd 06 05:25 AM
Countif over several worksheets	Barb Reinhardt	Excel Worksheet Functions	2	June 27th 06 03:55 PM
=COUNTIF across Worksheets	Trevor Shuttleworth	Excel Worksheet Functions	6	December 8th 05 10:58 PM
countif across worksheets	MCK	Excel Worksheet Functions	7	July 5th 05 05:15 PM

All times are GMT +1. The time now is 04:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us