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....... :-)
|