sum based on character value
Posted on 2011-02-20
I would like to add up the values of cells based on a character that represents where the value is from. for instance:
cells might contain
2P, 12X, 8V
where is would indicate 2 hours personal time(P), 12 hours training (X) or 8 hours vacation(V)
in the cells that contain the totals I would like excel to count the hours based on the letter. So the training column would only count cells in the row where the number is followed by X. I have no idea how to use VBA so I'm looking for a formula to do this if possible.