How do I leave out te value of a hidden row and not include it in my formula?
N Niek Otten Jan 11, 2006 #2 Select all the cells. Edit>Go To, click Special, check Visible cells only Insert>Name>Define, let's say "HalfRange" =SUM(HalfRange)
Select all the cells. Edit>Go To, click Special, check Visible cells only Insert>Name>Define, let's say "HalfRange" =SUM(HalfRange)
G Gee Jan 11, 2006 #4 Excellent!!! Thanks very much! Niek Otten said: Select all the cells. Edit>Go To, click Special, check Visible cells only Insert>Name>Define, let's say "HalfRange" =SUM(HalfRange) Click to expand...
Excellent!!! Thanks very much! Niek Otten said: Select all the cells. Edit>Go To, click Special, check Visible cells only Insert>Name>Define, let's say "HalfRange" =SUM(HalfRange) Click to expand...
