Hi,
I have a range of cells, say, A1 to P100. I would like to search for names plus adjacent number of hours in this range of cells (example cell A1 is Joe 5hrs, A2 is Diane 6hrs, C5 is Joe 3hrs, D8 is Chris 2hrs.
So then, I would like, example columns S1 to S3 to be: 8, 6, 2, representing the total number of hours of each person.
If I add another entry in E5 as Diane 3hrs, column S updates to 8, 9, 2. And so on.
I looked into a mixture of COUNTIF, ISNUMBER and SEARCH, but it was getting too complex for me.
Any help would be appreciated.
Thanks
I have a range of cells, say, A1 to P100. I would like to search for names plus adjacent number of hours in this range of cells (example cell A1 is Joe 5hrs, A2 is Diane 6hrs, C5 is Joe 3hrs, D8 is Chris 2hrs.
So then, I would like, example columns S1 to S3 to be: 8, 6, 2, representing the total number of hours of each person.
If I add another entry in E5 as Diane 3hrs, column S updates to 8, 9, 2. And so on.
I looked into a mixture of COUNTIF, ISNUMBER and SEARCH, but it was getting too complex for me.
Any help would be appreciated.
Thanks