Hi Experts,
I'm after a bit of help.
I have a spreadsheet that details Pass/Fail rates. I would usually just use a VLookup to calculate but the way the spreadsheet is created it has merged data.
From the attached example rows 5 & 6 the total has been merged in Column F. however in Columns K - N the values are in individual rows (from a different spreadsheet based on Column Data B & D)
I need a formula that will look up the individual data from Row F and calculate it as a total in Columns K - N rather than provide it as individual row data in Columns K - N. In the example Row 6 Column O- R will be empty.
The only data that is unique will be in Column D, however merged data will use the same number found in Column B.
Not sure if I have explained that very well
Bookmarks