sum

2 Topics

How to count and sum "Condtional formatting" cells by color in Excel 2010?
I installed few add-ins for counting "Conditional formatted" cells but all are generating an instant (one-time) numeric result by activating that command. Also, I tried a code which gives an instant counting of 1 picked color without a total sum of all other colors -in my case 12 colors in a matrix. ("How to use the code to count colored cells and sum their values" - https://www.ablebits.com/office-addins-blog/2013/12/12/count-sum-by-color-excel/ ) My question is: Is there any functional code (or other aproach) which can count and sum all cells by "Conditional formatted" colors, on one sheet, and that the generated result is linked through common formulas? That can be updated/refreshed/code run during the work process as a complete overview of colors of a matrix (and not by picking every color every time as I mentioned). Thanks in advance!
Solved
Deleted
Jan 29, 2024 Place Excel
280KViews
1like
181Comments
Query Help please
I am still quite a beginner at this SQL querying, so I appreciate any help on this. I have pulled the data I need using the below query. Now I need to group the data by cmp_name and sum the ivh_totalcharge for each cmp_name. Also, need to make sure I pull distinct records from the field ord_hdrnumber from the invoiceheader table. Thank you for any help, I appreciate it.
Tim Hunter
Mar 27, 2019 Place SQL Server
1.3KViews
0likes
1Comment