The Count & Sum by Color app will save you much time on calculating and recalculating highlighted data in your Excel for Mac.
#In my excel for mac, get to see the names of the colors when choosing them in cells free
Just click on the needed cell and click OK on the dialog box:įeel free to use the One Color tab each time you need to see the results just for the color you specify. You'll get the Count & Sum by Color dialog box letting you pick the top left cell for pasting the calculations. If you want to paste the results to your table, just click on the Paste results. On the add-in pane you'll instantly see Sum, Count, Average, Min and Max calculated for the cell data of the specified color: Select Font if it's the text color you want to use. The address of the selected cell will automatically appear in the Pattern cell field.ĭefine if you want to use the Background or Font color for calculation:Ĭlick the Background radio button to count the selected data by the fill color. You'll get the Count & Sum by Color dialog box that lets you select a pattern cell with the right color: To do this, click on the Select range button next to the Pattern cell field: Now you need to specify the correct color by choosing the cell that contains the necessary fill or font in your table. You can also click on the Select range button to pick the necessary range manually: Select the range in your table and you will see its address in the Select range field: Open the Excel table where you need to calculate cell values and run the Count & Sum by Color app by clicking on its name under the tab: The One Color tab on the Count & Sum by Color pane lets you instantly calculate cell data based on the color you select. If you use multiple different colors to group and highlight data in your Excel 2011 tables, you may need to pick a certain color and use it to calculate cell values. Select any cell in your current or new worksheet for adding the numbers and click OK to see the calculation results added:
button to see the Count & Sum by Color dialog box: This handy calculating tool also lets you paste the results from the app's pane to any location on your spreadsheet.Ĭlick on the Paste results.
Average - determine the average of the values.You can then pick any function from the Show results for drop-down list to see the needed calculation results: The app will quickly perform all math operations on your data. The results will be displayed on the Count & Sum by Color pane grouped by color codes: Press the Calculate button to process the range: Select the Font radio button to process the selected values by their text color. Press the Background radio button to calculate by the color of cells. Now you can specify the color option by selecting the Background or Font radio button: It's also possible to click on the Select range button to pick the necessary area manually: Highlight the needed range in your table and you will see its address in the Select range field: You'll see the Count & Sum by Color pane open. If you need to sum or count all highlighted cells in Excel 2011, first open the worksheet with your data and run the Count & Sum by Color app by clicking on its name under the tab: If you are fond of using different color codes to highlight certain parts of data, this helpful app will show you Sum, Count, Average, Min or Max for the colored cells. Count & Sum by Color app will become your reliable assistant in adding or counting cell values grouped by colors.
0 kommentar(er)
