Posted to microsoft.public.excel.worksheet.functions

Sean

external usenet poster

Posts: 454

Sumproduct Q

I am trying to create a SUMPRODUCT formula that will multiply I16:I33
x J16:J33, but only if -

J16:J33 = 0.21

AND

M16:M33 = 2000

Formula below is wrong, perhaps someone can direct me

Thanks

=SUMPRODUCT(--(J16:J33=0.21),(M16:M33=2000),I16:I33)

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	BillyHank	Excel Worksheet Functions	5	November 2nd 06 03:22 PM
sumproduct	erik550	Excel Discussion (Misc queries)	1	March 7th 06 07:45 PM
Like Sumproduct, But Different	ericsh	Excel Worksheet Functions	6	August 11th 05 05:49 PM
Sumproduct Help	Rob	Excel Worksheet Functions	11	August 8th 05 10:00 PM
MAX/MIN with SUMPRODUCT	[email protected]	Excel Worksheet Functions	7	August 3rd 05 02:10 AM

All times are GMT +1. The time now is 03:50 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us