A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Count number of cells until blank cell is reached



 
 
Thread Tools Display Modes
  #1  
Old June 22nd 10, 01:39 PM
Patrick Hourigan Patrick Hourigan is offline
Junior Member
 
First recorded activity by ExcelBanter: Jun 2010
Posts: 1
Post Count number of cells until blank cell is reached

Hey everyone,

I have a list of product lines in column K, and I would like to count the number of cells, or rows, until a blank cell is reached. There is a blank cell when a total is computed for those product lines.

I am working with a pivot table in Excel 2003, so the order of the table is organized by name (column J), then by product line. The total (column L) computed is for each person's name and creates a blank cell in column K before the next persons number of product lines begins.

Since this is a pivot table that will be updated about twice a year, the number of rows will change, which is why I want to count until the first blank cell is hit, then I will have a total for that person, and hopefully this can be done for each person following.

If there is a function(s) that I can use that would be best, otherwise I can try VBA.

Thank you in advance!
Ads
  #2  
Old August 4th 10, 04:00 PM
wickedchew wickedchew is offline
Senior Member
 
First recorded activity by ExcelBanter: Aug 2010
Location: Philippines
Posts: 155
Default

Quote:
Originally Posted by Patrick Hourigan View Post
Hey everyone,

I have a list of product lines in column K, and I would like to count the number of cells, or rows, until a blank cell is reached. There is a blank cell when a total is computed for those product lines.

I am working with a pivot table in Excel 2003, so the order of the table is organized by name (column J), then by product line. The total (column L) computed is for each person's name and creates a blank cell in column K before the next persons number of product lines begins.

Since this is a pivot table that will be updated about twice a year, the number of rows will change, which is why I want to count until the first blank cell is hit, then I will have a total for that person, and hopefully this can be done for each person following.

If there is a function(s) that I can use that would be best, otherwise I can try VBA.

Thank you in advance!
SUMPRODUCT will do the trick.
http://www.bygsoftware.com/Excel/fun...sumproduct.htm
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Count cells based on whether another cell is blank or not luvnrocs Excel Worksheet Functions 8 July 17th 08 03:50 AM
Maximum Number of Blank Cells between Non Blank Cells in a Range Mal Excel Worksheet Functions 5 November 3rd 07 09:21 AM
Counting blank cells until value is reached Dan Excel Worksheet Functions 9 March 1st 06 01:56 PM
Adding a certain number until minimum is reached dk Excel Discussion (Misc queries) 3 December 7th 05 02:29 AM
Autofill until blank cell is reached uberathlete Excel Discussion (Misc queries) 7 November 4th 05 06:43 PM


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


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