The surrounding { } indicate it is an array formula entered with CTRL +
SHIFT + ENTER

What would you like to troubleshoot?


Gord Dibben MS Excel MVP

On Thu, 11 Sep 2008 09:01:01 -0700, BeveyG
wrote:

Good morning,

{=SUM(IF($L$19:$L$148<0,$L$19:$L$148,0))}

Can someone help me troubleshoot the above formula. It is used on a
worksheet in a multi-function workbook (created by someone else - who is no
longer with the company and I can not ascertain their goal). The above
formula is used in a Trend Log for Change Orders, Pending Issues, etc. which
tracks debits and credits for each in one column. The above formula appears
in the cell just as it is shown above?????

Help! I have beaten my brain to death....

Thanks.

BeveyG

"In Memory of those who lost their lives - may we someday have Peace on
Earth and Good Will Toward All Men."