COUNT IF NOT

browning.m

Hi! I have this formula:

=COUNTIF({G3 - Range 1}; AND(@cell >= TODAY(); @cell <= TODAY(60)))

I want to add a condition that says {G3 - Range 2} is not equal to "concluded"

Paul Newcome

Try "range; criteria" syntax.

{Range}; @cell <> "concluded"

Paul Newcome

You would use a COUNTIFS (with the "S" on the end) to allow for multiple range/criteria sets and then follow the syntax of range; criteria; range; criteria.

browning.m

@Paul Newcome It's giving invalid operation =COUNTIFS({G3 - Range 1}; AND(@cell >= TODAY(); @cell <= TODAY(60)); NOT({G3 - Status } = "concluded"))

Paul Newcome

Try "range; criteria" syntax.

{Range}; @cell <> "concluded"