#1   Report Post  
Connie Martin
 
Posts: n/a
Default COUNTIF

What would the formula be to count the number of line items? If I have 383
rows typed, I want the formula to calculate that. If I add another 20 rows,
I want the formula to automatically update to 403.

Thank you
Connie Martin
  #2   Report Post  
Connie Martin
 
Posts: n/a
Default

Never mind! I figured it out. Posted my question too soon. I just used:
=COUNT(B1:B500) and it gives me the answer I want. I used row 500 because
that will always be well past the typed rows, so it will always ensure not to
miss counting any.

Connie


"Connie Martin" wrote:

What would the formula be to count the number of line items? If I have 383
rows typed, I want the formula to calculate that. If I add another 20 rows,
I want the formula to automatically update to 403.

Thank you
Connie Martin

  #3   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
=COUNTA(A1:A1000)

--
Regards
Frank Kabel
Frankfurt, Germany

"Connie Martin" schrieb im
Newsbeitrag ...
What would the formula be to count the number of line items? If I

have 383
rows typed, I want the formula to calculate that. If I add another

20 rows,
I want the formula to automatically update to 403.

Thank you
Connie Martin


  #4   Report Post  
Alex Delamain
 
Posts: n/a
Default


The simplest way is

=counta(A1:A65536)


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=274579

  #5   Report Post  
Alex Delamain
 
Posts: n/a
Default


If column B contains text then you should use =COUNTA instead


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=274579

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating an EXCEL COUNTIF formula for a range of values Pat Walsh Excel Discussion (Misc queries) 5 January 21st 05 03:57 PM
"countif" from multiple worksheets within workbook Excel Discussion (Misc queries) 2 December 10th 04 07:59 PM
Subtotal And Countif Sheryl Excel Discussion (Misc queries) 4 December 9th 04 08:18 PM
countif, again Liz G Excel Worksheet Functions 2 November 2nd 04 12:20 AM
combining countif formulas Liz G Excel Worksheet Functions 3 November 1st 04 10:34 PM


All times are GMT +1. The time now is 10:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"