Quote:
Originally Posted by Claus Busch
Hi Mark,
Am Fri, 28 Jun 2013 17:45:52 +0100 schrieb Mark74w1:
=SUM(T8:U27)-(IF(ISBLANK('Cost Plus Invoice'!O8:O1500)," ",('Cost Plus
Invoice'!T8:U1500)))
try:
=SUM(T8:U27)-SUMPRODUCT(--('Cost Plus Invoice'!O8:O1500=""),('Cost Plus
Invoice'!T8:T1500+'Cost Plus Invoice'!U8:U1500))
Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|
Mr. Clause
I copied and pasted the formula and got a #REF! Error.
I checked that the formula spelled out correct places and it seems correct.
Mark