Posted to microsoft.public.excel.programming

external usenet poster

Posts: 137

sumproduct problem

HI,
I have sumif formulas which work fine, but when combine them as sumproduct,
result is #NUM!, why?
=SUMIF(Data!B:B,A8,Data!D:D) - answer
=SUMIF(Data!C:C,LEFT(B8,3),Data!D:D) - answer
=SUMPRODUCT(--(Data!B:B=A8),--(Data!C:C=LEFT(B8,3)),(Data!D:D)) - #NUM!
Rgds

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
Problem with Sumproduct	Maureen	Excel Discussion (Misc queries)	4	March 31st 09 05:00 PM
SumProduct problem	John	Excel Worksheet Functions	5	February 23rd 09 01:52 AM
Big SUMPRODUCT problem	CLR	Excel Programming	3	June 22nd 08 04:22 PM
SUMPRODUCT Problem	Madiya	Excel Programming	5	October 26th 06 01:34 PM
Sumproduct problem	Helen	Excel Programming	4	January 14th 05 04:47 PM

All times are GMT +1. The time now is 10:39 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us