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


=IF(COUNT(A1:A6)<COUNTA(A1:A6),"",SUM(A1:A6))

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

Or, alternatively:

=if((count(Range)-counta(range)=0,sum(Range),"")

Aladin




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


Much better. Thank you.