Andre Croteau

Posts: n/a

Is it possible to have a 3D sumif result?

Hello,

I tried to do a 3D sumif formula, but it didn't work.
=sumif(sheet1:sheet6!a1,"0") but I got a #VALUE

Does anyone have a method that can be used to get the result that I want?
And could the solution be used for the "Countif" and "Average" functions as
well?

Thanks in advance

André

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
"1235" appears as "One thousand two hundred thirty five"	H. Kan	Excel Discussion (Misc queries)	11	December 8th 06 07:56 PM
excel	melissa	Excel Worksheet Functions	2	August 19th 05 09:46 PM
I NEED HELP with the SPELLNUMBER Function	vag	Excel Worksheet Functions	0	June 21st 05 08:17 AM
EXCEL:NUMBER TO GREEK WORDS	vag	Excel Worksheet Functions	1	June 15th 05 05:57 PM
Is there a formula to spell out a number in excel?	Sha-nay-nay	Excel Worksheet Functions	2	December 18th 04 09:25 PM

All times are GMT +1. The time now is 12:25 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us