fbpx

All articles with 'sumifs' Tag

SUMIF works in 2D too [quick tip]

Published on Apr 27, 2010 in Learn Excel
SUMIF works in 2D too [quick tip]

We all know that SUMIF formula can be used to find the sum of values meeting a criteria. Like this, But I was pleasantly surprised to realize that SUMIF works equally well for 2D ranges too, like this: During a recent consulting work with a client I had a requirement to sum up values that […]

Continue »

Making a Dynamic Dashboard in Excel [Part 2 of 4]

Published on Mar 30, 2010 in Charts and Graphs, Learn Excel
Making a Dynamic Dashboard in Excel [Part 2 of 4]

In part 2 of Excel Dynamic Dashboard Tutorial, we will learn how to set up various dynamic charts that are part of the dashboard. We start with a simple dynamic pie chart that shows the sales distributions and then move on to sales trend line charts. These charts use various excel formulas to pull in the information based on user selection.

Continue »

What is Excel SUMPRODUCT formula and how to use it?

Published on Nov 10, 2009 in Featured, Learn Excel
What is Excel SUMPRODUCT formula and how to use it?

Today we will learn a new and exciting excel formula – the all powerful SUMPRODUCT.

At the outset SUMPRODUCT formula may not seem like all that useful. But once you understand how excel works with lists (or arrays) of data, the SUMPRODUCT’s relevance becomes crystal clear.

Continue »