Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct or Countif - Counting Occurances within a Date Range
I have a spreadsheet that looks a little like this:
A B C 1 LA 24974 October-08 2 LM 24977 October-08 3 LM 24977 November-08 4 LM 24978 November-08 Colum C is a DATE, which is formatted to "mmmm-yy" I need to count the number of occurances of each of the values in Colum A, per month. The resutls would look like this: OCTOBER NOVEMBER LA 1 0 LM 1 2 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif or sumproduct using a date range and another criteria | Excel Discussion (Misc queries) | |||
Sumproduct - I think - Counting occurances that fall into criteria | Excel Discussion (Misc queries) | |||
Counting date occurances | Excel Worksheet Functions | |||
Counting Occurances across a range of sheets | Excel Discussion (Misc queries) | |||
SumProduct/CountIf dilemna + Date Range | Excel Worksheet Functions |