Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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
