Posted to microsoft.public.excel.programming

Mike

external usenet poster

Posts: 3,101

Summing

I have a database query that retuns data by date range. After the data is
returned
i enter in this formula in Columns G and H down to the last row of Data. Is
there a code to run a macro to do this

Thanks Mike

Column G
=SUM(E6-D6) ' Subtracts the New Price from Old Price
Column H
=SUM(F6*G6) ' New Price * QTY

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
summing	captsamm(remove)@comcast.net	Excel Discussion (Misc queries)	4	December 11th 09 05:38 PM
Summing it up	Violet 1	Excel Worksheet Functions	5	October 28th 08 08:57 PM
Summing 2 ifs	Steve	Excel Worksheet Functions	7	March 12th 08 03:11 PM
PivotTable and summing/not summing	~Amanda~[_2_]	Excel Discussion (Misc queries)	1	March 14th 07 07:35 PM
Summing	No Name	Excel Programming	5	June 15th 04 11:36 PM

All times are GMT +1. The time now is 04:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us