COUNTIFS nested with AND

Hello community, I need your help.

I want to count how many rows meet the following conditions:

1. The rows where the value of the column {ESTADO} equals "Espera".

2. The rows where the value of the column {RESULTADO} is empty.

3. The rows where the value of the column {DATE} is greater than 7 days but less than 14.


I am using the following:

=COUNTIFS({FECHA LIMITE}, AND({FECHA LIMITE} > (TODAY() - 14), {FECHA LIMITE} < (TODAY() - 7)), {ESTADO}, "Espera", {RESULTADO}, "")


The range is the entire column of another sheet.

The error is this: #INVALID OPERATION





data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAQAAAAngNWGAAAA/0lEQVR4AYXNMSiEcRyA4cfmGHQbCZIipkuxnJgMStlMNmeyD2dwmc8+sZgxYJd9ErIZFHUyYYD7fkr6l4/rnvmtl7+KitrqV/fq2Y5eLY3Z9S48eRLe7BmVZ9qhTLhQ0algzZWQOVKSsCF8OjAnwbxDTWFDUhPK/jMr1H6HE/IqRky2DyvCefuwItwZzodVoYRiLqMkVCXrwpJ9twZ+sgfDYEFYl8wIWxZ9uFf7zkallxlJh4YrLGsKjZRx7VGHhLqwgFUN45DGdb8MeXGpgB4ABZdeDcpZEY51A+hyLKz4S1W4MQWm3AibWtgWmk6dyISa1pSdyWTOlLXVp0+eL9D/ZPfBTNanAAAAAElFTkSuQmCC There was an error displaying this embed.


Best Answer

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Answer ✓

    Try this slight change. =COUNTIFS({FECHA LIMITE}, AND(@cell > (TODAY() - 14), @cell < (TODAY(- 7))), {ESTADO}, "Espera", {RESULTADO}, "")

    Does this help get you results?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!