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.
