MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Please help me with this small problem!

Posted by Anna Daly on December 19, 2000 5:09 AM

Hi All,

I have a little problem that I was hoping that someone could help me with.

I am tring to sum a range of cells in a worksheet only if all of the cell values in that range <> "-". It seems simple but I don't know how to do it with out using VBA code. Can you suggest a formula that I can use directly in the worksheet?

thanks for your help,

kind regards

Anna Daly

Posted by cpod on December 19, 2000 5:31 AM

Try this:

{=IF(SUM(N($A$1:$A$6<0))=0,SUM($A$1:$A$6),"")} Array function

Posted by Celia on December 19, 2000 5:51 AM


Posted by Aladin Akyurek on December 19, 2000 6:14 AM

Or, alternatively:



Posted by cpod on December 19, 2000 6:53 AM

Much better. Thank you.