sweetbrwnshugar
New member
Hi everyone!
I’m a novice to coding but I actually need an Excel formula for my attendance tracker project.
I was wondering if anyone knows an EXCEL formula or even a VBA code that will give the total sum of any numbers within cell that has specific TEXT inside the same cell ?
For example I need to be able to type VAC8 into any range of cells within my spreadsheet to represent vacation time taken by the employee in the amount of 8 hours (or any other number), then have the sum of the hours for every specific VAC attendance code populate in another cell within the spreadsheet. I'd need to be able to sum the numbers next to all the different attendance codes. The attendance codes I'm using are below. I added the actual attendance tracker I'm trying to create.
Attendance Codes
I’m a novice to coding but I actually need an Excel formula for my attendance tracker project.
I was wondering if anyone knows an EXCEL formula or even a VBA code that will give the total sum of any numbers within cell that has specific TEXT inside the same cell ?
For example I need to be able to type VAC8 into any range of cells within my spreadsheet to represent vacation time taken by the employee in the amount of 8 hours (or any other number), then have the sum of the hours for every specific VAC attendance code populate in another cell within the spreadsheet. I'd need to be able to sum the numbers next to all the different attendance codes. The attendance codes I'm using are below. I added the actual attendance tracker I'm trying to create.
Attendance Codes
VAC |
FMLA |
SL |
FLT |
WB |
P-VAC |
SVC |