Posted to microsoft.public.excel.worksheet.functions

barry houdini[_4_] barry houdini[_4_] is offline

external usenet poster

Posts: 57

SUMPRODUCT with If condition

Hello JPS,

Perhaps try changing to an "array formula" like this

=SUM(IF(IF(Other!$J$2:$J$10000<"",Other!$J$2:$J$1 0000,Other!$G$2:$G
$10000)=C$4,IF(Other!$O$2:$O$10000="",Other!$H$2: $H$10000)))

Needs to be confirmed with CTRL+SHIFT+ENTER so that curly braces
appear around the formula in the formula bar

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 'Or' Condition	pdberger	Excel Worksheet Functions	2	December 28th 07 10:56 PM
sumproduct-condition as a range	amh	Excel Discussion (Misc queries)	3	July 26th 07 05:36 PM
SUMPRODUCT with an IF condition?	FARAZ QURESHI	Excel Discussion (Misc queries)	4	May 5th 07 05:31 AM
Sumproduct: condition with ?	Sarah	Excel Discussion (Misc queries)	3	November 1st 06 06:33 PM
Sumproduct with condition???	neda5	Excel Discussion (Misc queries)	5	December 14th 05 02:09 AM

All times are GMT +1. The time now is 01:36 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us