I'm not sure if this works for you, but maybe:

=countif(a1:a5,"L")*10
(in A6)

sross002 wrote:

Here's how my graph is
a b c d e
1 L L L
2 L L L L
3 L L
4 L L L
5 L
6 30 20 20 30 30

How do I get the L's to represent $10.00 but still have the L in the graph
then when I add them i show the L's added up as numbers?

Basically, what formula will help me get the added sums of L's in numerical
form like in row 6 in my graph?

--

Dave Peterson