SOLVED
Home

Stats Formula help needed

%3CLINGO-SUB%20id%3D%22lingo-sub-304625%22%20slang%3D%22en-US%22%3EStats%20Formula%20help%20needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304625%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%203%20sheets%20in%20my%20file%20and%20I'm%20trying%20to%20create%20a%20formula%20for%20my%203rd%20sheet%20'Stats'%20referencing%20information%20from%20my%201st%20sheet%20'Open%20Incidents'.%20This%20information%20that%20I%20need%20is%20from%20B2%3AB100%20and%20how%20many%20times%20the%20value%20%2F12%2F2018%20appears%20however%20I'm%20not%20sure%20how%20to%20create%20formulas%20referencing%20other%20sheets.%20Also%20if%20the%20value%20in%20column%20B%20on%20sheet%201%20is%20a%20full%20date%20E.G%2001%2F12%2F2018%20would%20this%20still%20pick%20out%20the%20%2F12%2F2018%20in%20the%20formula%3F%20Quite%20new%20to%20Excel%20so%20thanks%20for%20any%20help%20in%20advance!%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-304625%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-304659%22%20slang%3D%22en-US%22%3ERe%3A%20Stats%20Formula%20help%20needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304659%22%20slang%3D%22en-US%22%3E%3CP%3EBrilliant%2C%20thank%20you!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-304650%22%20slang%3D%22en-US%22%3ERe%3A%20Stats%20Formula%20help%20needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304650%22%20slang%3D%22en-US%22%3E%3CP%3EThat%20could%20be%20like%3C%2FP%3E%0A%3CPRE%3E%3DCOUNTIFS('Open%20Incidents'!B2%3AB100%2C%22%26gt%3B%3D%22%26amp%3BDATE(2018%2C12%2C1)%2C'Open%20Incidents'!B2%3AB100%2C%22%26lt%3B%3D%22%26amp%3BDATE(2018%2C12%2C31))%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
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
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 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
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies