Index Match question

[DroZ3]

I have an issue (rather my boss has an issue) with a blank row in a list resulting from a Index-Match formula, here is the detail of my issue :

I have a list (partial list below) which is the result of an export from our ERP system.
Row A shows transaction items in the ERP.
Rows B and C show the employee ID and hours logged in the transaction.
Because of other formulas, I need to keep the rows with a transaction number (Sxxx) but NO corresponding employee ID (column B) or hours (column C).

That being said, in another sheet I am doing a INDEX MATCH to index all the employee ID in order to sum all the hours per employee.
Problem is that the blank rows in the sheet above result in a blank row in the following sheet, see row 32 below.

SanitizedTBPList is the vertical range of employee ID starting with cell B3 in the first image above.

Question : How can I modify the formula (green arrow) to skip the blank rows in the first image above ?

Thanks in advance for the help.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)