Formulas
Hi Saadia
A pivot table would probably be your best bet. Look at Data... Pivot Table
& Pivot Chart report
Best rgds
Chris Lav
"Saadia" wrote in message
...
I have an excel spreadsheet, where i keep track of how many estimates were
sent out by our estimators, the date it was sent out, approved, started,
completed, invoiced etc...
My boss wants to know how many $ worth of estimates was sent out by each
estimator every week, running month, last month, running quarter, last
quarter, running year and last year. Any easy way to set this up that
excel
automatically calculates all this.
Any help would be appreciated.
Thanks :)
|