Hello, Is it possible to have a summary row at the top of my sheet that is "locked" sort of. Meaning, when i filter on certain criteria, the summary row will only total that criteria.??
While it isn’t possible to have a row that shows a summary of filtered data, there are formulas such as SUMIF and COUNTIF that will sum and count only cells that meet a criteria you specify. If this is what you are looking for, check out this Help Center article on formulas: http://help.smartsheet.com/customer/portal/articles/775363-using-formulas
