Sum only numbers?!
It works fine - given the assumptions. It was copied from the formula bar -
the cell was displaying the correct sum. If it shows just the sum of the
numbers not preceded by letters, then you have not entered it with with
Ctrl+Shift+Enter as instructed.
However, you say it is displaying nothing - hard for a working function to
do that - is the cell displaying the formula. Do you have a space in front
of the Equal sign?
--
Regards,
Tom Ogilvy
"dove_g" wrote in message
...
On Wed, 3 Sep 2003 07:34:15 -0400, "Tom Ogilvy"
wrote:
Assume values are in A1:E1 and non numeric entries start with a single
letter.
=SUM(IF(ISNUMBER(A1:E1),A1:E1,RIGHT(A1:E1,LEN(A1: E1)-1)*1))
Hm, that's not vorking at all?! No value.
|