View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
J_L_G J_L_G is offline
external usenet poster
 
Posts: 1
Default 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