Forum Discussion

AllyDee's avatar
AllyDee
Copper Contributor
Feb 13, 2020

Excel formula error

Please help! So this is my formula "=SUM(COUNTIFS(Feb!H2:H28,{"CHSP"},Feb!A2:A28,{">=03/02/2020"})-COUNTIF(Feb!A2:A28,">07/02/2020"))". Essentially I am trying to calculate whenever we enter CHSP wit...
excel
Formulas and Functions
Twifoo's avatar
Twifoo
Silver Contributor
Feb 13, 2020

AllyDee 

You can simplify your formula like this: 

=COUNTIFS(Feb!H2:H28,"CHSP",

Feb!A2:A28,">="&StartDate,

Feb!A2:A28,"<="&EndDate)

Note that StartDate and EndDate in the foregoing formula must be either Named Cells or Cell addresses wherein the dates are stored. 

  • AllyDee's avatar
    AllyDee
    Copper Contributor
    Feb 16, 2020

    Twifoo Thank you so much for your help, that worked. I really appreciate it and I see now from other answers where I went wrong with my formula.