Dec 20 2018 02:56 AM
Hi all,
I have 3 sheets in my file and I'm trying to create a formula for my 3rd sheet 'Stats' referencing information from my 1st sheet 'Open Incidents'. This information that I need is from B2:B100 and how many times the value /12/2018 appears however I'm not sure how to create formulas referencing other sheets. Also if the value in column B on sheet 1 is a full date E.G 01/12/2018 would this still pick out the /12/2018 in the formula? Quite new to Excel so thanks for any help in advance!
Dec 20 2018 03:56 AM
SolutionThat could be like
=COUNTIFS('Open Incidents'!B2:B100,">="&DATE(2018,12,1),'Open Incidents'!B2:B100,"<="&DATE(2018,12,31))
Dec 20 2018 03:56 AM
SolutionThat could be like
=COUNTIFS('Open Incidents'!B2:B100,">="&DATE(2018,12,1),'Open Incidents'!B2:B100,"<="&DATE(2018,12,31))