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