SOLVED
Home

Formula cross referencing

%3CLINGO-SUB%20id%3D%22lingo-sub-304667%22%20slang%3D%22en-US%22%3EFormula%20cross%20referencing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304667%22%20slang%3D%22en-US%22%3E%3CP%3EAfternoon%20all%2C%20I%20need%20some%20help%20in%20creating%20a%20formula%20that%20will%20generate%20the%20amount%20of%20'YES'%20values%20within%20I2%3AI100%20against%20a%20date%20range%20in%20B2%3A100%20(Full%20month%20span%20E.G%201%2F12%2F18%20-%2031%2F%2F12%2F18).%20The%20information%20is%20on%20sheet%201%20'Open%20Incidents'%20and%20I%20need%20this%20formula%20to%20be%20on%20sheet%203%20'Stats'%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20short%20I%20need%20a%20formula%20that%20will%20show%20me%20the%20amount%20of%20Escalations%20within%20the%20calendar%20month.%3C%2FP%3E%3CP%3EI've%20taken%20a%20look%20online%20but%20couldn't%20find%20anything%20regarding%20this%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20(sorry%20new%20to%20Excel)%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-304667%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-304687%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20cross%20referencing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304687%22%20slang%3D%22en-US%22%3E%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)%2C'Open%20Incidents'!I2%3AI100%2C%22YES%22)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
lmrly_
New Contributor

Afternoon all, I need some help in creating a formula that will generate the amount of 'YES' values within I2:I100 against a date range in B2:100 (Full month span E.G 1/12/18 - 31//12/18). The information is on sheet 1 'Open Incidents' and I need this formula to be on sheet 3 'Stats'

 

In short I need a formula that will show me the amount of Escalations within the calendar month.

I've taken a look online but couldn't find anything regarding this

 

Thank you (sorry new to Excel)  

1 Reply
Highlighted
Solution
=COUNTIFS('Open Incidents'!B2:B100,">="&DATE(2018,12,1),'Open Incidents'!B2:B100,"<="&DATE(2018,12,31),'Open Incidents'!I2:I100,"YES")
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
29 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