Help trying to auto calculate one cell when other cells are populated.

[Randy Tibbits]

[#2]

Please state your question in plain text in the message, rather than in a screen-shot. This ensures other people may find your question and potential answers to it.

[#3 · Accepted solution]

Hi Randy,

Please try this formula in cell B5:

=OFFSET(A3,-1,COUNTA(B3:M3))/MAX(B3:M3)

Regards

[#4]

I need to automatically calculate a value in one cell (i.e B5) when the value of other cells are updated

the formula I am currently using is SPI(B5)=f2/MAX(b3:m3)

F2 is the month of May, so when I receive the info for the month of June which will be G2, I would like the SPI value to auto calculate with out having to update the formula.

Hope this makes sense.

[#5]

That worked perfectly.  Thank you so much for your help!

[#6]

Thank you for adding your question!