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

You could wrap your sum formula in an IF() statement so if a cell is blank, the sum formula does not calculate. Something like:

=IF(A1="","",SUM(A1*B1))

There is even an Excel Function, called ISBLANK()

=IF(ISBLANK(A1),"",F1/G1)

MIKE

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. http://office.microsoft.com/en-us/e...

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

Ask Your Question

Weekly Poll