SOLVED

Stats Formula help needed

Copper Contributor

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!  

2 Replies
best response confirmed by lmrly_ (Copper Contributor)
Solution

That could be like

=COUNTIFS('Open Incidents'!B2:B100,">="&DATE(2018,12,1),'Open Incidents'!B2:B100,"<="&DATE(2018,12,31))

 

Brilliant, thank you! 

1 best response

Accepted Solutions
best response confirmed by lmrly_ (Copper Contributor)
Solution

That could be like

=COUNTIFS('Open Incidents'!B2:B100,">="&DATE(2018,12,1),'Open Incidents'!B2:B100,"<="&DATE(2018,12,31))

 

View solution in original post