Quote Originally Posted by Fotis1991 View Post
As my poor English does not help me, can you pls tell me in columns BK & BL, which are the expected(correct) results and why?
BK and BL are correct. Apologies, I don't think I made it clear enough.

The problem is with the 'chart feed' table, starting in BV column to the right of the 'top 5 FMEA' table. The expected value in BW7 would be 330, as it is the result that links the column header (electrodes >7 days wait) and the date (Feb-13) in the left hand main table.

I suppose instead of referencing the header 'electrodes >7 days wait' and then looking for the bottom values, I could use a formula to find the intersection of 'electrodes >7 days wait' in row 3:3 and the date 'Feb-13' in column A:A?

I hope this clears things. Please let me know if it still needs clarification. I know it is complicated, it confuses me a bit too :P