Posted to microsoft.public.excel.misc

Spheon

external usenet poster

Posts: 11

'smart' dragging

how can i enter this formula in the spreadsheet so I can
drag it where the A2 only changes relative to the cell ie

=SUMPRODUCT((Invoices!A5:A1000=A2)*(Invoices!G5:G1 000))
drag this one to get....
=SUMPRODUCT((Invoices!A5:A1000=A3)*(Invoices!G5:G1 000))
=SUMPRODUCT((Invoices!A5:A1000=A4)*(Invoices!G5:G1 000))
etc when I drag all the figures change to this
=SUMPRODUCT((Invoices!A6:A1001=A23)*(Invoices!G6:G 1001)) etc

:(

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
How do I get more smart tag recognizers?	SonyaD24	Excel Worksheet Functions	2	June 10th 07 07:05 PM
person name smart tag	Judith	Excel Discussion (Misc queries)	0	March 12th 07 03:37 PM
Smart tags	Filly	Excel Worksheet Functions	0	February 2nd 06 03:24 AM
Smart Paste	GKW in GA	Excel Discussion (Misc queries)	1	September 8th 05 04:13 AM
smart tags	Tom_in_Jersey	Excel Discussion (Misc queries)	2	August 29th 05 09:56 PM

All times are GMT +1. The time now is 07:06 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us