In this example, I have written a macro function #COLORBASEDSUM# to add cell values based on their colours. When you are given a data which has colours in it and if you need to add those values based on colours, this would definitely help.
Download the file which illustrates how to use the macro function to get the desired result
https://drive.google.com/file/d/0Bz7...it?usp=sharing
If you have problems in downloading the file from the above link, use the uploaded file in this posting
Note:
In case if the colouring on the cell has been done based on any logic, you could directly use the same logic in SUMIF or SUMIFS to get the results.
Download the file which illustrates how to use the macro function to get the desired result
https://drive.google.com/file/d/0Bz7...it?usp=sharing
If you have problems in downloading the file from the above link, use the uploaded file in this posting
Note:
In case if the colouring on the cell has been done based on any logic, you could directly use the same logic in SUMIF or SUMIFS to get the results.
1 Attachment(s) [Login To View]