Forum Discussion

Row89's avatar
Row89
Copper Contributor
Jun 08, 2022
Solved

Help with COUNTIF with multiple critera

Hi   I have tried the below formula, however it is not working. I would like to count the rows if the date (SDMF Tasklist (build)'!E:E) is due within the next 7 days but it also has to have the sta...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Jun 08, 2022

    Row89 

    =COUNTIFS('SDMF Tasklist (build)'!E:E,"<="&TODAY()+7,'SDMF Tasklist (build)'!E:E,">="&TODAY(),'SDMF Tasklist (build)'!C:C,"Not Started")

    You can try this formula if the due date is from TODAY up to TODAY+7.

    =COUNTIFS('SDMF Tasklist (build)'!E:E,">="&TODAY()+7,'SDMF Tasklist (build)'!E:E,"<="&TODAY()+14,'SDMF Tasklist (build)'!C:C,"Not Started")

    You can try this formula if the due date is from TODAY +7 up to TODAY+14.

Row89's avatar
Row89
Copper Contributor
Jun 08, 2022
also, how would i create my next formula, which would need to be:

count the rows if the date (SDMF Tasklist (build)'!E:E) is due in 7-14 days but it also has to have the status "not started".

Resources