View Single Post
  #1   Report Post  
jim314
 
Posts: n/a
Default conditional counting

Here is my data (in actuality, it's about 35,000 rows long and will be
growing at the rate of 1,000 rows per month) and it's in a sheet I've labeled
as "Format 1".

TYPE (column A) PERIOD (column B) VERSION (column C)
DS 02/2005 1
BS 02/2005 2
WS 03/2005 2
DS 02/2005 1

I want to be able to count all of the different combinations that occur
(i.e., count all of the "DS and 02/2005 and 1") and return them in a sheet
I've labeled "Results"

There is too much data for a pivot table and I know there's a solution using
sumproduct (or something like that), but I haven't been able to figure it
out.

Any ideas?

Thanks,

Jim