Fybo

Posts: n/a

COUNT over several sheets...Part 2!

Thanks for all your help guys...and quick!!

I've tried =SUM(January 2005:December 2005!D34) but the cell just displays
the function and not the result. Is the function wrong or am I missing
something.

Have I got all the spaces and characters correct?

Is it possible that because there are no values in the later sheets (ie
September 2005, Cell D34 will be blank) that the function isn't working?

Thanks again, Fybo.

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
COUNT over several sheets	Fybo	Excel Discussion (Misc queries)	6	March 8th 05 04:40 PM
Conversion	SVC	Excel Worksheet Functions	9	February 28th 05 02:29 PM
Part Number/Qty Consolidations	[email protected]	Excel Discussion (Misc queries)	2	February 6th 05 09:21 PM
Count the text in a column - Part II	Peter Curtis	Excel Discussion (Misc queries)	3	January 6th 05 06:58 PM
count cells over multiple sheets	Have three columns R,S,T	Excel Worksheet Functions	4	December 18th 04 01:36 PM

All times are GMT +1. The time now is 09:45 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us