Blog & Excel Tips

Blog entries covering the latest Excel tricks and tips based on queries from clients and practical knowledge from our consultants.

Sum cells by colour with the Data Filter Feb 9, 2022

As indicated in a previous post, one of the tools that 'notices' colours in Excel cells is the Data Filter. By combining this with some other tools/ functions you can get a sum, count or average of the coloured cells.

Consulting

We aim to provide the ultimate, one stop shop for all Excel users requirements, within South Africa and worldwide.

Find Out More

Live Training

"Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude."

Find Out More