This video shows how the SUMIF and AVERAGEIF functions are used to calculate conditional sums and averages based on a single criterion. It also shows how the SUMIFS and AVERAGEIFS functions are used to calculate conditional sums and averaged based on multiple criteria.
These are the two files needed to follow along to this video:
Excel With Wayne is an online Microsoft Excel Training Course taught by Dr. Wayne Winston. Dr. Winston is the world’s foremost Microsoft Excel Expert that teaches at some of the world’s largest organizations including Microsoft and government organizations such as the Navy and Army.
Please confirm you want to block this member.
You will no longer be able to:
Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.
