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.
From India, Chennai
23Download 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.
From India, Chennai
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.
Values and culture.ppt
Sample Competency Based Interview Questions.doc