Forum Discussion

lmrly_'s avatar
lmrly_
Copper Contributor
Dec 20, 2018
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 inform...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Dec 20, 2018
    =COUNTIFS('Open Incidents'!B2:B100,">="&DATE(2018,12,1),'Open Incidents'!B2:B100,"<="&DATE(2018,12,31),'Open Incidents'!I2:I100,"YES")
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Dec 20, 2018
=COUNTIFS('Open Incidents'!B2:B100,">="&DATE(2018,12,1),'Open Incidents'!B2:B100,"<="&DATE(2018,12,31),'Open Incidents'!I2:I100,"YES")

Resources