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
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Values and culture.ppt
Sample Competency Based Interview Questions.doc