Posted to microsoft.public.excel.programming

MikeF[_2_] MikeF[_2_] is offline

external usenet poster

Posts: 173

challenging sumifs?

Need to sum columns x,y,z on another sheet by criteria on the original sheet.

So sum columns x,y,z from sheet Detail --- 100 rows, x1:z100 - the sum
range.

Via criteria range on sheet Detail - a1:a100

Where the Detail sheet row matches [lookup?] criteria on sheet Summary k12.

Have looked at it too long!
Any assistance will be greatly appreciated.

Thanx,
- Mike

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
A challenging One	[email protected]	Excel Programming	5	March 18th 08 12:37 PM
challenging	George	Excel Programming	0	March 28th 07 02:06 AM
Challenging?	ChrisMattock[_24_]	Excel Programming	7	June 7th 06 04:16 PM
Very challenging	madcat	Excel Programming	2	June 25th 04 02:13 AM
Something Challenging	Swift2003[_4_]	Excel Programming	3	April 17th 04 09:03 AM

All times are GMT +1. The time now is 05:39 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us