| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum only numbers?!
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)) Sorry Tom, it's Ok now. I see now that I must have *1 in RIGHT command so with that I get value number. And point is if there is any field empty, empty * 1 gives no value result. So I just add small code: SUM(IF(LEN(A1:E1)=0;0;your formula) Thank you a lot Tom. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
| VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| to find missing serial numbers in randomly generated numbers | Excel Worksheet Functions | |||
Threaded Mode
