GaryStone10
Board Regular
- Joined
- Nov 18, 2008
- Messages
- 100
Hi All
I have a formula here
=SUBTOTAL(1,B2:B32) which I use because I need to only total the visible cells in the range.
Is there a way in which I can modify this formula to ignore zero values within this range as well?
I know I could make a new set of columns with =If(B2<>0,B2,""), but I was wondering if there was a neater way.
Thanks in advance.
Gary.
I have a formula here
=SUBTOTAL(1,B2:B32) which I use because I need to only total the visible cells in the range.
Is there a way in which I can modify this formula to ignore zero values within this range as well?
I know I could make a new set of columns with =If(B2<>0,B2,""), but I was wondering if there was a neater way.
Thanks in advance.
Gary.