Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am after trying to get a total for a range that includes numbers and text,
or a combination of the two. Eg I need to add A 5(h) B 3(2h) C 2(2s) D 3(2H) Total = 13 Total H = 5 Total S = 2 I have able to count the cells with H and S in, but need to return the total numbers of H, and that of S. The simple solution I know would be to have 2 seperate columns for the number and the number of h's, that's easy, but not as interesting, or an option at this time. Any help towards this would be appreciated. Thanks in advance --b AB120 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with summing numbers in cells that also contain text | New Users to Excel | |||
summing cells with text and numbers | Excel Worksheet Functions | |||
Summing cells that contain numbers and text | Excel Discussion (Misc queries) | |||
summing numbers with in a cell | Excel Discussion (Misc queries) | |||
Independently Summing Multiple Text Options Within a Cell | Excel Worksheet Functions |