Forum Discussion
How can i keep adding a number to the number that shown in the cells?
Hey everyone, im new in EXCEL, trying to build a stock control for my business. im trying to add a inventory for my excisting inventory and i dont know how to do it. let me ask it more simply, let...
Two things cannot occupy the same physical space. F2 cannot hold the values 2 and 6 at the same time.
You could put the numbers you want to add in their own cells below F2 and sum them using a formula like (note the sum function ignores text):
=SUM(20,F:F)
Otherwise, if you want to do it the way you are trying, it would require vba.