The count/sum formulas are extremely handy.
We would also love to take it to the next step: conditional counts/sums, so that you can count or sum data for only rows required. The functionality can get pretty deep, but it would be amazing just to be able to hook to the filtering options.
For example, Count column C where (column A in XYZ)
This has been delivered! You will need to create a new lookup to use the feature and if you select any of the special calculation level lookups you can now choose to apply filters to limit which results are included in the count/sum/min/max etc... Let us know if you have any questions.
We really need this as well.0
Please sign in to leave a comment.