This Add-In is great! Worked as soon as I installed. AbleBits…More Please!!!!
Estimation application downloads and cost
Description
If you use font or background color in your table to highlight certain cells or group similar data, Count & Sum by Color app will help you work with colored cells. With this app you can:
• count colored cells;
• sum cell values based on their color;
• calculate average;
• find minimum and maximum values;
• paste the results to your table.
When you work with the app you can choose the below options:
• show results for the selected color;
• display results for all colors in groups;
• choose the font or background color option.
You may find the app helpful for one of the following tasks:
• Count survey responses in your table (yes/no – green/red);
• Determine the number of items remaining in each store (sum the cell values based on their color);
• Quickly find the best result by displaying the maximum value in the table. For example, if the best result of each period is colored green.
• Fast analysis of the Financial Statements – find minimum and maximum numbers.
Read more
• count colored cells;
• sum cell values based on their color;
• calculate average;
• find minimum and maximum values;
• paste the results to your table.
When you work with the app you can choose the below options:
• show results for the selected color;
• display results for all colors in groups;
• choose the font or background color option.
You may find the app helpful for one of the following tasks:
• Count survey responses in your table (yes/no – green/red);
• Determine the number of items remaining in each store (sum the cell values based on their color);
• Quickly find the best result by displaying the maximum value in the table. For example, if the best result of each period is colored green.
• Fast analysis of the Financial Statements – find minimum and maximum numbers.
Count & Sum by Color for Microsoft Excel screenshorts
Application availability
Available in countries
| Country | Price |
|---|---|
| Canada | free |
| China | free |
| France | free |
| Germany | free |
| Italy | free |
| Netherlands | free |
| Portugal | free |
| Spain | free |
| Poland | free |
| UK | free |
| India | free |
| Japan | free |
| Korea, Republic Of | free |
| Poland | free |
| Russia | free |
| Turkey | free |
| USA | free |
| Korea, Republic Of | free |
| Ukraine | free |
Available for devices
MacDesktop,Reviews
Great Add-In
Stuck with the app!
App is great and works fine, but I don’t need it anymore and want to uninstall it. Unfortunately, this is impossible and I am stuck with the app. It’s showing in the Excel menubar and could not be removed, although the app itself have been uninstalled.
Doesn’t work
Can’t even apply the application to Excel, it immediately gives this error every time: "Run-time error 1004: Method Add of object AddIns’ failed"
The App Doesnt Even Open!
The app doesnt even launch. I tried everything to have it open and it still refuses to do so. All the criterias are met, and it still wouldnt open!
Does one job very well
Worked great and was easy to use especially considering the lack of macros in OS X. Also appreciated it summarizing for me since my experience with pivot tables is quite limited. It does a good job quickly of what it claims to do. Nicely done.
Will Not Perform Calculations
All was going great, until I tried to run the calculations radio button….crash….wawawa. Really want to use this, so hopefully its just a bug and it will get fixed soon.
Snappy helper
I schedule my weekly time slots by color. This gives a quick view of time blocked for each activity. It does not enter results into cells within the spreadsheet, only shows them in a pop-up window. If that is all you need, this is perfect! (If you need the count to appear within your worksheet look for a VBA solution.)
Other apps from Add-in Express
Similar apps
