Having a nightmare at the moment with some formula's I've been asked to 'fix'. It would seem the users expected them to work with closed source spreadsheets but they don't. So they end up having to open about 10 spreadsheets to get all the values added in.
I've tried to figure out how to change from Countif to Sumproduct which seems to be the only resolution but with no such luck.
Hoping an Excel Guru out there can assist.
Formula as it stands now…:
=COUNTIFS('S:\Data\HQ\2014\Report.xlsx'!Table2[RFI Date],">="&B1,'S:\Data\HQ\2014\Report.xlsx'!Table2[RFI Date],"<="&B2)