« HAPPY NEW YEAR 2015Sum Values Based on Two Conditions »
Dec 31

SUM based on Colour (No Cast & No Religion)

Formulas, CF

Hi there,

 

In this post, I will be sharing three slides on how to SUM values based on colour, without considering its cast and its religion ;)

Let me know what you have understood after reviewing these three slides. And, if you still requires explanation on this post, please post your comment as "Explain Please". 

 

Here we go:

...

 

SUM Values based on Cell Colour using Excel
 
SUM Values based on Cell Colour by revealing helper column using Excel
 
SUM Values based on Cell Colour by revealing helper column and formula using Excel
 
DID YOU SUM COLOURS?

Please teach us how you use to sum values based on colour in your work using below comments section.
If you like this post, please do share it on your social networking sites by clicking on the icons placed around the blog.
If you like to receive such posts to your email id, REGISTER your email id with us. We love information security.


SOME IMPORTANT LINKS:


CTRL + ENTER

Dynamic DropDown Lists

Sort the Sorted List

Difference between a Link & an Object


Thanks,

You must be logged in to see the comments. Log in now!

If you have no account yet, you can register now! (It only takes a few seconds)

Contact / Help. ©2020 by Abhilash VK. Design & icons by N.Design Studio. Skin by Tender Feelings / Evo Factory.
Entries RSS Comments RSS Log in