Please can you help; I need to amend the formula held in sheet2 of my workbook ("Stats table") cell reference F6.
The formula current counts B14:B2000 sheet1
I need to amend this formula so that it only counts within a particular date range. The date range will be From/To F3:F4
So only dates which fall between “from” and “to” would be returned in the total count.
For example B17 sheet 1 would be omitted from the total count because the 07/03/2011 falls outside the date range in F3:F4 Sheet 2