testing cells in a row

[thomas donino]

I am trying to check whether there are any values in, for example row 10
cells A-M and IF there are any values in ANY of those cells then I will total
A10:M10 in cell N10. I am having trouble with the IF code for cell N10 to
check the other cells for values

 

[JLGWhiz]

If Application.Sum(Range("A10:M10")) > "" Then
N10 = Application.Sum(Range("A10:M10"))
End If

 

[thomas donino]

That is for VB I assume, can I put a formula in cell N10 that works the same
way?

 

[john]

see if this does what you want. Place in N10

=IF(SUM(A10:M10),SUM(A10:M10),0)

 

[Dana DeLouis]

That is for VB I assume..

Hi. This is in excel.programming. :>)

As a worksheet formula, perhaps:

=IF(COUNT(A10:M10)>0,SUM(A10:M10),#N/A)

(#N/A to your choice of course)
= = = = = = =
HTH :>)
Dana DeLouis