COUNTIFS nested with AND

Cesar Hernandez

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

Mike Wilday

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

Does this help get you results?

Mike Wilday

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

Does this help get you results?

Cesar Hernandez

Excellent thank you very much

Mike Wilday

You're welcome. When using AND or OR in a COUNTIFS statement your AND or OR statements should use the @cell instead of the reference again. :D