![]() |
#1
|
|||
|
|||
![]()
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....... :-) |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
jrasche2003@yahoo.com | Excel | 2 | 02-09-2007 07:10 AM |
Don't count 0 in a chart | Rmaisone | Excel | 0 | 08-21-2006 12:26 PM |
Automatically entering/fill data in cells in Excel 2003 | dipdog | Excel | 0 | 08-17-2006 08:37 AM |
![]() |
pumpkin head | Excel | 1 | 02-17-2006 09:06 AM |
![]() |
jvieille | Misc | 1 | 02-11-2006 06:26 AM |