I need to first find the column number where the number 1 resides on the "Lookup Value -->" row.
Next, I need to shift two columns to the right, which would be "4/2019 C" and sum the values for Client B,
I have tried various combinations of SUMIFS, INDEX(MATCH()), etc.,but with my last attempt, I received #INVALID VALUE with the following formula:
=SUMIFS(INDEX(Client1:[5/2019 C]4, MATCH(1, Client5:[5/2019 C]5, 0) + 2), Client1:Client4, "Client B")
Please help! Thank you.