MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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.

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

Thanks

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

Thanks

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

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

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

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


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

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


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