ImaniBrownQrew Member7 years agoSimple formula to sum or average a column in a reportI have an imported/synced spreadsheet and I just want to sum and average the # of Assets column. I can't figure out how to do this in the formulas. In Excel it would be Sum(D2:Dn). Show More
ImaniBrownQrew Member7 years agoThanks. After asking I realized that I had the field defined as a text field so I wasn't being shown the options.
Related ContentPercentages are Sums instead of Averages on the Total and Averages RowsFormula URL - Edit then AddFormula Help - Average Productivity Per DayCreate a formula duration over 5 yearsCalculating Percentage Average of Consent Date Entries: Seeking Formula Assistance
Recent DiscussionsFilter Monthly, Quarterly, Yearly from one Date fieldExtrapolating nuanced dataSolvedForms helpShare your feedback on the new Qrew DiscussionsGenerating QR Code with URL to record