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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct or Countif - Counting Occurances within a Date Range
=SUMPRODUCT(--(Sheet1!$A$1:$A$10=Sheet2!$A2),--(TEXT(Sheet!$B$1:$B$10,"mmmm")=Sheet2!B$1))
copy down and across. -- __________________________________ HTH Bob "J_L_G" wrote in message ... 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 |
Reply |
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 |