How to hide unused cells when running accumulated totals

G

grano2

I am running 2 columns to do accumulated totals. I have a formula such as
this: Cell b2 = a2+b1,
Cell c2 = b2+c1 ect.
I want to hide the accumulated totals until the cell in column one gets a
value. How can I accomplish this?
Thanks
grano2
 
K

Kassie

Hi

Instead of =A2+B1, use =IF(A2="","",A2+B1) B2+C1 will change to

=IF(B2="","",B2+C1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Avoiding auxiliary cells 0
countifs Function not giving desired result with date criteria 2
Copying formulas across columns 2
Need help calculating probabilities 7
Running total with IF statements 2
Hyperlinks with lookups 0
LOOKUP Function 4
adding every other column 8

Top