Calculate with Conditions

Hi guys,

Please see attached document.

My help is needed with the calculations on column M:M.

instead of having to put the tedious manual formula as it is showing. Is there a way to make this dynamic, so if I add columns to the table, it will atomically add those to the calculation? Also, Can we add a condition utilizing M4 Cell. to only calculate the Columns in the table if 4:4 row equals the number/value in M4.


I'm pretty sure I did a horrible job explaining what I'm looking for, please let me know what clarity is needed

lmao, John,

you are amazing, I'm sure that was so simple for u, thanks!!