Hi,
I have a spreadsheet that has numbers and "HW"numbers (HW02, HW07...) in the cells.
I need a formula that will find the HW in a range of cells and total the numbers that follows the HW.
I've tried this formula: SUMPRODUCT(TEXT(MID(B2:G9,FIND("HW",B2:G9&"HW")+2,3),"0;;;\0")) but it doesn't work. I've attached a sample image of what I'm looking for.
Thanks in advance.
I have a spreadsheet that has numbers and "HW"numbers (HW02, HW07...) in the cells.
I need a formula that will find the HW in a range of cells and total the numbers that follows the HW.
I've tried this formula: SUMPRODUCT(TEXT(MID(B2:G9,FIND("HW",B2:G9&"HW")+2,3),"0;;;\0")) but it doesn't work. I've attached a sample image of what I'm looking for.
Thanks in advance.