| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF + Month
Hi,
I have date ranges in column B (B3:B503) If the month in the date ranges is a specific month then i need to count up the data placed in Column G (G3:G503). =COUNTIF('[Name.xls]Mid-Term'!$G$3:$G$503,'[Name.xls]Mid-Term'!$B$3:$B$503) Now i'm not very familiar with many of the functions within excel, so can anyone suggest how to complete the above formula. Thanks, Phendrena |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif month & year | Excel Worksheet Functions | |||
| CountIf by Month-to-date | Excel Worksheet Functions | |||
| transfer cell $ amount to other sheet month-to-month without overc | Excel Discussion (Misc queries) | |||
| countif number of occurences per month per year. | Excel Worksheet Functions | |||
| How do I get the COUNTIF criteria to recognize only month and yea. | Excel Worksheet Functions | |||
Threaded Mode
