You have a range A3:A100, with cells in this range having string values either "A", "B", "C" or "D". And you want to get SUM(A3:A100)? It's no brainer - it will be always 0!




Or did you want something else?

I'm soooo sorry. Not sure what I was thinking when I wrote this.

So the values would be:

A's=100
B's=75
C's=50
D's=25


In the A3:A100 range, I would have 25 A's, 25 B's, 25 C's and 23 D's.

So all of that would equal

A=2500
B=1875
C=1250
D=575
--------
6200


What would the syntax for the formula be to yield the sum of 6200?


Thank you