|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
Mar 30th, 2004, 03:22 PM
|
#1 |
|
Join Date: Sep 2003
Posts: 40
|
Formula to count the number of rows
Hi,
I'm seeking a formula that will count the number of rows. I have a list of invoices that changes with each update. I need to keep a running total of the number of invoices. Please let me know if there is a formula. Thanks, Steve |
|
|
|
Mar 30th, 2004, 03:24 PM
|
#2 |
|
MrExcel MVP
Join Date: Sep 2002
Location: Alabama/State of Disarray
Posts: 10,473
|
Re: Formula to count the number of rows
Any blank rows in the range?
Is the range filled with text or numeric data?
__________________
just_jon Book of the Month: I'm Not Really an MVP, I Just Play One on TV [j. jon, 2004] 
|
|
|
|
|
Mar 30th, 2004, 03:25 PM
|
#3 |
|
Join Date: Aug 2003
Location: England
Posts: 4,584
|
Re: Formula to count the number of rows
Hello,
Probably a better way but I use this =COUNTIF(A:A,"<>")
__________________
------------------------- Hope this is helpful. ------------------------- only a drafter, but broadening my Excel knowledge. |
|
|
|
|
Mar 30th, 2004, 03:33 PM
|
#4 |
|
MrExcel MVP
Join Date: Sep 2002
Location: Alabama/State of Disarray
Posts: 10,473
|
Re: Formula to count the number of rows
OK; Data in column A, some blanks --
=COUNTA($A$1:$A1000) will give you a count of how many cells in A1:A1000 have something in them
__________________
just_jon Book of the Month: I'm Not Really an MVP, I Just Play One on TV [j. jon, 2004]
|
|
|
|
|
Mar 30th, 2004, 03:34 PM
|
#5 |
|
Join Date: Sep 2003
Posts: 40
|
Hi Onlyadrafter,
your formula works perfectly...thank you very much. Hi Just_Jon, thank you also for getting back to me. Steve 
|
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
