| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Compare if same month in cell vs columns
On sheet 1 I have the months across the top row and lets say that the month
of March is in c1. On sheet 2 I have a column (d1:d20) with many dates, and I want to count the number of dates in the month of March. I think it would go something like this, =countif(month(sheet 2(d1:d20)),sheet 1(c1)) I may not have all of the () in the right place but hope you get the idea. Thansk |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 queries: Display last cell, and compare two lists | Excel Worksheet Functions | |||
| Cell formating and Rolling columns | Excel Discussion (Misc queries) | |||
| Truncating a columns worth of cells not just a single cell. | Excel Worksheet Functions | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| Syntax for inferred cell references | Excel Worksheet Functions | |||
Threaded Mode
