Counting records

[lcrooke]

I have a spreadsheet with the following structure:

Date Type Jan Feb Mar
1/15/2009 corp $1,000
1/31/2009 vendor $3,000
2/12/2009 corp $5,000
2/20/2009 renewal $1,500
3/1/2009 renewal $2,500
3/4/2009 corp $3,000
3/26/2009 vendor $6,000

Total $4,000 $6,500 $11,500

Count:
Corp
vendor
renewal


The dollars are in a column for the appropriate month based on the date. I would like to get counts for each month by type. I could easily do this if I was looking for the total value by using sumif function. But I cannot figure out how to get a similar result for a count. I tried using dcount function, but I think I just do not get it or it is not the right function

Please help!

 

[lenze]

My suggestion is to redo your layout. You do not need the columns for each month since you already have the date. So
Date ----Type----Amt
will suffice. Now just use a Pivot Table to get the info you need
lenze