Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 22nd 10, 01:39 PM
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!

  #2   Report Post  
Old August 4th 10, 04:00 PM
Senior Member
 
First recorded activity by ExcelBanter: Aug 2010
Location: Philippines
Posts: 161
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


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
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 08:21 AM
Counting blank cells until value is reached Dan Excel Worksheet Functions 9 March 1st 06 12:56 PM
Adding a certain number until minimum is reached dk Excel Discussion (Misc queries) 3 December 7th 05 01:29 AM
Autofill until blank cell is reached uberathlete Excel Discussion (Misc queries) 7 November 4th 05 05:43 PM


All times are GMT +1. The time now is 01:11 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017