![]() |
|
#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....... :-) |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
How to get cells to calculate time?
|
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 |
Multiple criteria in SUMIF?
|
pumpkin head | Excel | 1 | 02-17-2006 09:06 AM |
Filtering past or future events in DRW query criteria
|
jvieille | Misc | 1 | 02-11-2006 06:26 AM |