Posted to microsoft.public.excel.misc

external usenet poster

Posts: 50

SUMPRODUCT

Data are from D4:I14;

A1-1 1 Text 3 4 5
B1-2 6 7 8 9 10
C1-3 11 12 13 14 15

A2-1 16 17 18 19 20
B2-2 21 22 23 24 25
C2-3 26 27 28 29 30

A3-1 31 32 33 34 35
B3-2 36 37 38 39 40
C3-3 41 42 43 44 45

B1-2 =SUMPRODUCT(--(D4:D14=E18),E4:I14)

How can I make the above formula to be corrected? It is possible to used the
SUMPRODUCT function..I want to sum the numbers to the right of B1-2, which is
40.

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
Conditional SUMPRODUCT or SUMPRODUCT with Filters	Ted M H	Excel Worksheet Functions	4	August 14th 08 07:50 PM
Help with SUMPRODUCT please : )	Sierra	Excel Worksheet Functions	5	November 8th 07 01:04 AM
sumproduct? sumif(sumproduct)?	David	Excel Worksheet Functions	3	July 13th 07 07:06 PM
sumproduct	Mandy	Excel Discussion (Misc queries)	3	February 8th 06 01:25 PM
=SUMPRODUCT	Jim	Excel Worksheet Functions	9	January 17th 06 04:52 PM

All times are GMT +1. The time now is 12:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us