Hi Excel community,
Trying to sum A, B, C values. If there is no number after a letter, then reference cell before (on the left).
If there is number after letter (or example A=10) then add to the sum "10".
Then get sums for each letter per specific period (month).
Columns E-G just to get an idea what I'd like formula to pull. Do not have Regex
Trying to sum A, B, C values. If there is no number after a letter, then reference cell before (on the left).
If there is number after letter (or example A=10) then add to the sum "10".
Then get sums for each letter per specific period (month).
Columns E-G just to get an idea what I'd like formula to pull. Do not have Regex