Excluding formulas in hidden cells?
 

If I type 1 in a1 and =sum(a1,1) in a2 then copy a2 and paste it in a3 thru
a100 I get 1, 2, 3, 4 and so on all the way down to 100. If I hide several
of the rows, it throws the numbering sequence off. How do I go about
excluding the hidden cells? Couldn't find a IsHidden or similar function to
through in an =if(LogicalTest,True,False) formula/function.

Excel 2003

Much Thanks !!!

Adam L. Kehl

Excluding formulas in hidden cells?
 

=SUBTOTAL(109,A3:A100)


"Adam L. Kehl" <Adam L. wrote in message
...
If I type 1 in a1 and =sum(a1,1) in a2 then copy a2 and paste it in a3
thru
a100 I get 1, 2, 3, 4 and so on all the way down to 100. If I hide
several
of the rows, it throws the numbering sequence off. How do I go about
excluding the hidden cells? Couldn't find a IsHidden or similar function
to
through in an =if(LogicalTest,True,False) formula/function.

Excel 2003

Much Thanks !!!

Adam L. Kehl

Excluding formulas in hidden cells?
 

Appreciate the quick response.

I'm already using SubTotal for one part of the spreadsheet. Don't
see/understand how to use it for this part.

Name First | Name Last | Last 4 of Social | Receipt No. | Amount Donated

John Doe 8715 1801
5
Mary Jane 3478 1802
20
Mike Smith 6243 1803
10

Total: 35

I've got a list of say, 100 people. Every week we take a Voluntary Fund
which is used for when one of us gets hurt or sick. The receipt numbers are
already printed on a triplicate form. I hide the rows for the people who
didn't donate and enter the amounts they donated (109 SubTotal works great
for the Total). My problem is I enter what I previously stated (the actual
column is D, not a) using the 1st/Next (they're consecutive numbers) receipt
number in my book. The hidden cells are still adding on to the counter so I
might see 1803 the 1805. Any suggestions?

"Gaurav" wrote:

=SUBTOTAL(109,A3:A100)


"Adam L. Kehl" <Adam L. wrote in message
...
If I type 1 in a1 and =sum(a1,1) in a2 then copy a2 and paste it in a3
thru
a100 I get 1, 2, 3, 4 and so on all the way down to 100. If I hide
several
of the rows, it throws the numbering sequence off. How do I go about
excluding the hidden cells? Couldn't find a IsHidden or similar function
to
through in an =if(LogicalTest,True,False) formula/function.

Excel 2003

Much Thanks !!!

Adam L. Kehl

Excluding formulas in hidden cells?
 

Question for you.

If there is no donation made by a person, you don't need the receipt number
to be there. Right? Also, you would not enter anything in the "Amount
Donated" column. Right?

Is there any other difference in donation and non-donation apart from
hiding the rows?



"Adam L. Kehl" wrote in message
...
Appreciate the quick response.

I'm already using SubTotal for one part of the spreadsheet. Don't
see/understand how to use it for this part.

Name First | Name Last | Last 4 of Social | Receipt No. | Amount Donated

John Doe 8715 1801
5
Mary Jane 3478 1802
20
Mike Smith 6243 1803
10

Total: 35

I've got a list of say, 100 people. Every week we take a Voluntary Fund
which is used for when one of us gets hurt or sick. The receipt numbers
are
already printed on a triplicate form. I hide the rows for the people who
didn't donate and enter the amounts they donated (109 SubTotal works great
for the Total). My problem is I enter what I previously stated (the
actual
column is D, not a) using the 1st/Next (they're consecutive numbers)
receipt
number in my book. The hidden cells are still adding on to the counter so
I
might see 1803 the 1805. Any suggestions?

"Gaurav" wrote:

=SUBTOTAL(109,A3:A100)


"Adam L. Kehl" <Adam L. wrote in message
...
If I type 1 in a1 and =sum(a1,1) in a2 then copy a2 and paste it in a3
thru
a100 I get 1, 2, 3, 4 and so on all the way down to 100. If I hide
several
of the rows, it throws the numbering sequence off. How do I go about
excluding the hidden cells? Couldn't find a IsHidden or similar
function
to
through in an =if(LogicalTest,True,False) formula/function.

Excel 2003

Much Thanks !!!

Adam L. Kehl