Formula - Count IFS

michellelkirkland

Hello,

i am having trouble with a calculation I am trying to use. The formula is :

=COUNTIFS({Original Due Date}, >=[Column22]@row, {Original Due Date}, <=[Column23]@row, {Days for Deviation Closure}, >30, {Days for Deviation Closure}, <61)

The calculation does not give me an error (all results return as 0, however, if I use the filter function with the same parameters I get different results (a different number for each set of dates.

Does anyone happen to see what in the calculation may be prohibiting it to count correctly?

Thanks!.

Dakota Haeffner

Hey Michelle,

Could we get some screenshots of the fields that are referenced in the formula?

michellelkirkland

Thanks for your quick response!