Please can someone help me with the attached?
Essentially I have one sheet of data and one sheet to summarise that data. The bits that I am summarising have varying complexities of formulas, from simple SUMIFs to SUMIF array formulas.
The real complexities come in when I start referring to text within the array - which by the way is essential to it all.
I have simplified my task at hand right down to the attached spreadsheet, but what ever the solution is it needs to be scalable.
A big smiley face to anyone who can solve the red cell using either an array formula or VLookup (I presume).
My thanks in advance!
Mike
Bookmarks