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

JKPieterse
Silver Contributor
Jul 16, 2018
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.
Haytham Amairah
Silver Contributor
Jul 16, 2018
Hi Randy,

Please try this formula in cell B5:
=OFFSET(A3,-1,COUNTA(B3:M3))/MAX(B3:M3)

Regards
- Randy Tibbits
  Copper Contributor
  Jul 16, 2018
  That worked perfectly. Thank you so much for your help!
  - JKPieterse
    Silver Contributor
    Jul 16, 2018
    Thank you for adding your question!
Randy Tibbits
Copper Contributor
Jul 16, 2018
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.

Forum Discussion