Sheet Summary COUNTIF

lmarchisio
lmarchisio ✭✭✭✭
edited 12/09/19 in Formulas and Functions

I'm having problems using the COUNTIF function in the new-ish sheet summary.  Everytime I sort rows it changes the range.  For example, in a summary text field I have

=COUNTIF([Column A]1:[Column A]79, =0)

After sorting by a column it becomes 

=COUNTIF([Column A]29:[Column A]43, =0).  Or something similar.

The sheet summary is supposed to be used for gathering metrics.  But I can't use it for this intended purpose if it means no longer sorting the sheet.  Anyone have advice?  This can't be the way its meant to work.

Thanks!

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!