Save 5 minutes a day by using ASAP Utilities to quickly get basic info and calculation results on your selection.
"How can I get a quick sum, avg, min, max, no of duplicates etc.?"
This utility provides info and performs a fast calculation on the selected cells.
Just select the cells and then start:
ASAP Utilities » Information » Fast calculation on selected cells...
It shows more information than Excel can show in its statusbar, and you can also copy the info that is reported in the white result-boxes.
The following information is shown/calculated:
- the number of selected cells
- the number of numeric cells
- the number of text cells
- the number of blank cells
- the sum
- the average
- the minimum value
- the maximum values
- the number of duplicates (values that appear more then once)
- the number of unique values
- values that appear only once
Just select the cells and the start:
ASAP Utilities » Information » Fast calculation on selected cells...
Bonus tips, also interesting
How much time will it save?
It's guaranteed that you'll save yourself time and effort by using this tool. However, the actual time saved depends on how much you use Excel, the amount of data you are working with and how often you use this particular tool.
You can easily see how much time ASAP Utilities has saved you so far.
Download
In case you don't have ASAP Utilities yet, you can download the free Home&Student edition (for home projects, schoolwork and use by charitable organizations) or the fully functional 90-day Business trial.
Download page