Why does this return the value of 0 when each range/criteria pair return 6 and 12 respectively?


=COUNTIFS([N/A]3:[N/A]20, 1, Done3:Done20, 1) This one returns 0. It should be 18

=COUNTIFS([N/A]3:[N/A]20, 1) This returns 6

=COUNTIFS(Done3:Done20, 1) This returns 12

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!