View Single Post
 
Old 06-05-2006, 07:59 AM
AdamNT AdamNT is offline
Novice
 
Join Date: Jun 2006
Posts: 1
AdamNT
Default How to count cells containing data and meet certain criteria

Can anyone help,

I want to count the number of cells in 2 columns that match 2 sets of criteria.

Basically I have a list of activities with dates next to them, like a record of work. I have on a separate page a table to summarise all the activities in rows and the months in columns.

In separate columns I have managed to:
- convert the full date to a numeric value ie; Jan = 1, Feb =2
- convert the "activity" to numeric value 1-20

I just need a formula to look down each column and count for each month how many times each activity occurs

Is this possible?

Please help....... :-)
Reply With Quote