LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default sum the number of rows in a spreadsheet given 2 criteria???

Hi,

I have a monthly sales report and i am trying to determine how many
customers we have at the end of each month for the last few years so i can
attempt to display the growth of our penetration.

The spreadsheet has in column C the name of the client (each client is
allocated its own row), the date (month end) is in column P, the product type
is in column G.

so essentially what i want i want to do is sum the number of rows for each
month for each product.

Any help is greatly appreciated!

Thanks in advance.
 
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
Counting number of rows between date range and meeting 2 string criteria Hii Sing Chung Excel Worksheet Functions 11 July 21st 09 12:34 AM
How to number lines (rows) on both sides of spreadsheet crb.e4xplor Excel Worksheet Functions 6 April 7th 07 01:00 PM
How to get number of rows which match criteria kiranmani Excel Worksheet Functions 6 July 11th 05 03:41 PM
Function to Count Number of Consecutive Rows with a Specific Criteria? Templee1 Excel Worksheet Functions 2 July 10th 05 10:22 PM
cells() and counting number or rows on spreadsheet HeatherO Excel Worksheet Functions 7 March 2nd 05 10:36 AM


All times are GMT +1. The time now is 03:34 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"