Posted to microsoft.public.excel.worksheet.functions

juliejg1

external usenet poster

Posts: 81

SUMPRODUCT question

I am looking at four columns:

A1 = Scorecard Date
B1:B20 = Different dates
D1:D20 = Record Value
E1:E20 = Spend

I would like to do the following:
For all records where the dates in column B match the date shown in A1, I
would like to sum D1:D20 and divide the total by the sum of E1:E20.

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 Question	porter444	Excel Worksheet Functions	2	September 25th 07 07:06 PM
SumProduct Question	mldancing	Excel Discussion (Misc queries)	15	April 6th 07 03:52 AM
SumProduct question	Jamesy	Excel Discussion (Misc queries)	5	March 31st 06 05:20 PM
Sumproduct Question	[email protected]	Excel Discussion (Misc queries)	9	March 10th 06 04:26 PM
another sumproduct question	cjjoo	Excel Worksheet Functions	9	November 18th 05 07:59 PM

All times are GMT +1. The time now is 08:46 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us