I'm not the most proficient with Excel, so please be patient. In a nutshell, I have inserted an IF statement in a cell like this:
=IF(E64="Resize","5","10")
As a result, if I type in "Resize" into one cell, it autogenerates a 5 in the adjacent cell. If I type anything else, it places a 10. So the range looks something like this:
New 10New 10Resize 5New 10
I then try to autosum the numbers, but it won't work. It only delivers a value of 0. My only functional workaround is to click each cell and then the plus sign and then the next cell and the plus sign and so on until I'm done. Very tedious.
Hopefully someone knows a way for me to autosum this column when I'm done entering data. Much appreciated.
=IF(E64="Resize","5","10")
As a result, if I type in "Resize" into one cell, it autogenerates a 5 in the adjacent cell. If I type anything else, it places a 10. So the range looks something like this:
New 10New 10Resize 5New 10
I then try to autosum the numbers, but it won't work. It only delivers a value of 0. My only functional workaround is to click each cell and then the plus sign and then the next cell and the plus sign and so on until I'm done. Very tedious.
Hopefully someone knows a way for me to autosum this column when I'm done entering data. Much appreciated.
