Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting number of rows between date range and meeting 2 string criteria | Excel Worksheet Functions | |||
How to number lines (rows) on both sides of spreadsheet | Excel Worksheet Functions | |||
How to get number of rows which match criteria | Excel Worksheet Functions | |||
Function to Count Number of Consecutive Rows with a Specific Criteria? | Excel Worksheet Functions | |||
cells() and counting number or rows on spreadsheet | Excel Worksheet Functions |