Thread
:
How to hide unused cells when running accumulated totals
View Single Post
#
2
Kassie
Posts: n/a
Hi
Instead of =A2+B1, use =IF(A2="","",A2+B1) B2+C1 will change to
=IF(B2="","",B2+C1)
--
ve_2nd_at. Randburg, Gauteng, South Africa
"grano2" wrote:
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
Reply With Quote