Understanding STDEV Add together all the cash flows you have put in the spreadsheet to calculate a total. Divide the total by the number of historical entries to calculate the mean average cash flow.