Archive of Mr Excel Message Board

Back to Dates in Excel archive index
Back to archive home

array formula

Posted by GregC on June 01, 2001 2:31 PM

I have an array formula that adds values even though the column with the qualifier is empty.
{=SUM(IF(h8:H70="DUE",g8:g70))} Any idea why it adds numbers in column "g" even though there is nothing in column "h"?

Thanks,

GREG

Re: array formula

Posted by Russell on June 01, 2001 3:06 PM

Maybe try re-entering the formula; I tried it and it worked like it is supposed to.

Thanks

Posted by Gregc on June 01, 2001 3:32 PM

Thanks

Posted by Gregc on June 01, 2001 3:33 PM

There was something wrong with the sheet. If I copied each sheet seperately the formulas work. I love when crap like that happens.

Ever considered writing up your array-formula differently as...

Posted by Aladin Akyurek on June 01, 2001 4:08 PM

{=SUM((h8:H70="DUE")*(g8:g70))}

Re: Ever considered writing up your array-formula differently as...

Posted by GregC on June 01, 2001 10:58 PM

Thanks! I love it when a different idea is given. There are so many ways to skin a cat. I won't forget that one.

Greg

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.