Posted to microsoft.public.excel.worksheet.functions

Steve[_4_] Steve[_4_] is offline

external usenet poster

Posts: 184

Sumproduct Offset with an If

Hi everyone. Is there a way to have a sumproduct embedded with an
offset function. Essentially, I will write the formula in Column C.
I need to scan column D, and for ever instance of the word "Sales"
multiply the cell directly to the right in column E by the cell in
column A, BUT 2 rows above! Possible? Thanks!!

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
Sumproduct Indirect Named Dynamic Range using Offset	Frank Hayes	Excel Worksheet Functions	6	May 6th 07 06:32 AM
OFFSET() not working within a SUMPRODUCT() when refering to a range in a pivot table	Conan Kelly	Excel Worksheet Functions	6	April 11th 07 12:32 AM
Sumproduct and offset	Maarten	Excel Worksheet Functions	4	October 28th 05 10:23 AM
Sumproduct with offset?	MJ	Excel Worksheet Functions	3	March 15th 05 03:34 PM
SUMPRODUCT using offset from ROW if X marks the spot	The Shaffer s	Excel Worksheet Functions	3	November 2nd 04 06:14 AM

All times are GMT +1. The time now is 11:52 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us