I would be grateful for some assistance with this formula that I am struggling to write properly.
Please see the excel table below. My aim is to rewrite the second part of the SUMPRODUCT (K5:K9) so that it looks up the relevant column based on the date in B1.
I have already achieved this with the formula in cell P2, but cant get it to work as part of the SUMPRODUCT.
So I'm looking for something like:
Thanks in advance for any suggestions.
Please see the excel table below. My aim is to rewrite the second part of the SUMPRODUCT (K5:K9) so that it looks up the relevant column based on the date in B1.
I have already achieved this with the formula in cell P2, but cant get it to work as part of the SUMPRODUCT.
So I'm looking for something like:
=SUMPRODUCT(C5:C9,column based on date in B1 matched with range D3:K3)/SUM(INDEX(D5:K9,,MATCH(B1,D3:K3))) |
Thanks in advance for any suggestions.