Blog & Excel Tips

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

Sign up to our newsletter at the bottom of the page.

Ignore zeros in average September 13, 2023

When you use the average function in Excel, it is important to decide what you want to do with zeros. Should they be considered in the average i.e. they are part of the calculation or should they be ignored i.e. the item is there but you want Excel to determine an average without taking that item into account.

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