0:00
Sum ifs in Excel. Double the conditions,
0:04
zero the effort. In Excel, if you want
0:07
to sum a value based on one or more
0:09
criteria, so we'll use the sum ifs
0:12
function. Let's look at the formula. We
0:15
have a table with product.
0:17
Our table includes product, region,
0:20
month, and sales. To sum the sales based
0:23
on multiple conditions, we'll use the
0:25
sum ifs formula. First, we define the
0:27
sum range. This will be the sales
0:29
column. Then we move to the criteria.
0:32
For criterion one, we'll choose the
0:36
Here we are working with products like
0:41
The criteria we've selected is the
0:46
After pressing enter, we saw the total
0:48
for laptop. Now let's filter for mobile
0:51
and see what result we get. So what does
0:54
it do? It adds up all the values for
0:56
laptop and does the same for mobile too.
1:01
It will sum the values accordingly. And
1:03
if you want to add more conditions, you
1:05
can simply extend the sum ifs formula
1:07
with additional criteria ranges and
1:09
values. You can easily add more
1:12
conditions. For criterion two, we'll use
1:14
the region column to refine the results
1:16
further. We'll choose north as the
1:20
region here. Now if we update the
1:22
criteria, our result will adjust
1:28
The result will update based on the
1:30
selected conditions. And yes, you can
1:32
even add a third criteria to make your
1:34
filtering more precise.
1:36
Now we'll add month as our third
1:38
condition and set the criteria to the
1:42
It can feel tricky at first, but with
1:44
this method, you can easily sum values
1:47
using multiple conditions in Excel.
1:50
And that's how you use sum ifs in Excel
1:53
to sum values based on multiple
