How to use the extra functions you get with ASAP Utilities

We have created a example workbook that shows how to get things done - that are normally not possible at all or difficult in Excel - by using the functions that ASAP Utilities adds.

Especially the function to calculate the SUM of cells with a certain color is a popular request and still can't be done in Excel itself without the use of a macro or add-in.

Worksheet functions added by ASAP Utilities
Calculate the sum of cells with a certain color
Get the text from a cell's comment into a cell

Furthermore, we have released a pre-release of the new version of ASAP Utilities.

More information and download of the example workbook and the pre-release:
http://www.asap-utilities.com/faq-questions-answers-detail.php?m=239

Comments are closed.

Pinterest