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