Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a row of 15 cells. In some of these cells there is text. The text
has numerical values such as V=1, M=0.5, and H=0.25. There are usually multiple combination of these text values and I would like to have a seperate cell show the SUM total within a range. I tried COUNTA, but that returns a whole number. I'd like to show a total where if I have V V M M H within a range, using the values above, in my "total" cell I will have the end result of 3.25. Any suggestions will be greatly appreciated -- TXEagle in SAT |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count Text Values in Column | Excel Discussion (Misc queries) | |||
How to use an array or matrix to return text vs. numeric values | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions | |||
how do i detect like text and add corresponding values? | Excel Discussion (Misc queries) | |||
text and values combined in one cel | Excel Discussion (Misc queries) |