Forum Discussion

lmrly_'s avatar
lmrly_
Copper Contributor
Dec 20, 2018
Solved

Stats Formula help needed

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...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Dec 20, 2018

    That could be like

    =COUNTIFS('Open Incidents'!B2:B100,">="&DATE(2018,12,1),'Open Incidents'!B2:B100,"<="&DATE(2018,12,31))

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Dec 20, 2018

That could be like

=COUNTIFS('Open Incidents'!B2:B100,">="&DATE(2018,12,1),'Open Incidents'!B2:B100,"<="&DATE(2018,12,31))

 

  • lmrly_'s avatar
    lmrly_
    Copper Contributor
    Dec 20, 2018

    Brilliant, thank you!