Solved Excel - automatic copy formulae on data entry

September 6, 2013 at 20:29:55
Specs: Windows 7
I have a table with several simple formulae in it, that sum data across a row.
Currently, I use the "Copy Down" function, but that produces several rows of zeros in the various columns where there is no data to compute.
Is there a way of entering data in, say column 1, that will invoke the formulae onto the current line, so I can have an aesthetic spreadsheet that expands as I enter data?
I tried to add a JPG that explains visually what I want, but the system wouldn't accept it. Sorry

message edited by happywanderer

See More: Excel - automatic copy formulae on data entry

Report •

September 7, 2013 at 06:22:27
You could wrap your sum formula in an IF() statement so if a cell is blank, the sum formula does not calculate.

Something like:


There is even an Excel Function, called ISBLANK()



Report •

September 7, 2013 at 07:54:15
✔ Best Answer
There are also a number of other ways to hide zero values as described at the link below. Examples include setting worksheet options, using conditional formatting, formulas, etc.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

Ask Question