SUMIFS function
Adds the cells that meet several conditions at once.
Syntax
=SUMIFS(sum_range, criteria_range1, criteria1, …)
| Argument | What it means |
|---|---|
sum_range | The cells to add. Note: it comes first in SUMIFS. |
criteria_range1 | The first range to check. |
criteria1 | The condition for that range. |
…optional | More range/condition pairs. Every condition must be true. |
Example
=SUMIFS(D2:D20,B2:B20,"North",C2:C20,"Laptop")
Adds sales where the region is North and the product is Laptop.
Try itType =SUMIFS( in E2 and click cells to fill in the arguments.
Click a cell, then type. Right-click for rows, columns, sort and filter.
A
B
C
D
E
F
G
H
I
J
K
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
Item
Qty
Price
Date
Try here
Apples
12
$0.50
2024-01-15
Bananas
30
$0.25
2024-02-29
Cherries
8
$3.20
2024-04-30
Dates
15
$2.75
2024-07-27
Figs
5
$1.90
2024-12-01