Forum Discussion
Solved
Formula cross referencing
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)
=COUNTIFS('Open Incidents'!B2:B100,">="&DATE(2018,12,1),'Open Incidents'!B2:B100,"<="&DATE(2018,12,31),'Open Incidents'!I2:I100,"YES")
1 Reply
=COUNTIFS('Open Incidents'!B2:B100,">="&DATE(2018,12,1),'Open Incidents'!B2:B100,"<="&DATE(2018,12,31),'Open Incidents'!I2:I100,"YES")