Hello,
Here is my example; exampleBook2.xlsx
I would like to add up total numbers associated with the different codes. For example line one should be: 16 CT, 8 OU, 1 Trng, 8 CE, 8 LS, 8 LA. The RDO code is not necessary, only fields with numbers. Also some cells with contain more than 1 code, which can probably make the formula much more complicated
To be a little more specific this is a time sheet record, LA, OU, CT, all reference different time of "time-off" or "time-earned". Incase that information may help with the development of a formula.
Thank you in advance!
Bookmarks