WANT TO STAND OUT?

Use the form on the right to contact us.

16192 Coastal Highway
Deleware
USA

intellitech.analytics.llc@gmail.com

Intellitech Analytics, LLC provides consultative benchmarking and analytics services for businesses seeking to separate themselves from the pack.

Tips for Excel Users

Filtering by Tag: AVERAGEIF

Remove Duplicates

June 07, 2015Evan Paulus

Learn how to use the Remove Duplicates feature of Excel to produce a quick summary table.

categories Excel Tips & Tricks
tags Remove Duplicates, SUMIF, AVERAGEIF, MEDIAN IF

SUMIF and SUMIFS

May 31, 2015Evan Paulus

At the core of Excel is the ability to perform basic mathematical operations on one of more values. The SUMIF and SUMIFS functions allow you to extend that ability by adding only when certain conditions are met.

categories Excel Functions
tags Excel, SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS