| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to sum numbers from cells containing letters and numbes
have table where I need to summ numbers from cells with letters beside numbers
A1=ED2, A2=ED1, A3=ED1, A4=ED4, A5=RE2... have formula =SUMPRODUCT(--RIGHT(E3:I3;1)) which is ok if there is no empty cell in the range, result is 10. can someone help to find right formula if cell A2 is empty ? thx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting cells with numbers and letters | Excel Discussion (Misc queries) | |||
| Count only Letters in cells that contain both letters and numbers | Excel Worksheet Functions | |||
| Formatting cells for letters and numbers | Excel Worksheet Functions | |||
| Sorting - cells containing numbers, numbers and letters | Excel Discussion (Misc queries) | |||
| How can I merge 2 cells with numbers and letters? | Excel Worksheet Functions | |||
Linear Mode
