I'm working on data from b3:ac76. Most cells have a value of zero, some cells have alphanumeric values (e.g. A6, A2, B1, J2). I want to be able to sum all numbers where the first letter is "A", then all values where the first letter is "B", and so on. Based on my example above, the value of A's would be 8, B's would be 1 and J's would be 2.I've tried several formulas, but the don't seem to sum the numbers and/or don't work in ranges of cells, just rows or columns.Any help would be appreciated!