SOLVED
Home

Stats Formula help needed

lmrly_
New 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
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! 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies