Data processing from table, ignoring blank data

Hi everyone,

I'm trying to create an excel sheet and I've hit a brick wall. The way I have this set up right now is that data is being submitted by an Infopath Web Form and emailed to me, it produced an XML file with values for all the possible entries for each person but only certain departments are filling in certain blocks.

That XML file is uploaded into a worksheet and then I'm trying to process data off that table to get the information I'm needing. I'm trying to divide data if a certain piece of the formula matches (IF CCU & August then Divide F column on same line by G column on same line and display the result)

I'm also trying to ignore empty blocks which is where my problem is at. So far I've come up with

Please Login or Register  to view this content.

but that is only working if the data happens to match on the same line in the data table.

Thanks,

RMRN11

EDIT: Added the excel workbook: patientdashboardexperience.xlsx