A
Andrewba
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
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