If there will only be 4A and 8A (not 3A, 5A etc) then
=(COUNTIF(A1:A11,"4A")*4+COUNTIF(A1:A11,"8A")*8)&" A"
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"jacobs" wrote in message
...
in column A (A1:A11)
m
4A
8A
m
Tr
m
m
4A
4A
8A
8A
i would like to add up all the 4A and 8A so that my total column would
be 36A
how can i do that?
many thanks for any help