| Function | Example |
| =SUMIF(range, criteria, [sum_range]) | =SUMIF(A1:A9, "Fuel", B1:B9) |
| =SUMIFS(sum_range, range1, value1, [range2, value2, ...]) | =SUMIFS(B1:B9, A1:A9, "Fuel", C1:C9, "12/15/20") |
| =COUNTIF(range, value) | =COUNTIF(A1:A9, "Food") |
| =COUNTIFS(range1, value1, [range2, value2, ...]) | =COUNTIFS(A1:A9, "Coffee", C1:C9, "12/15/2020") |
'Data Analytics > Excel & GoogleSheets' 카테고리의 다른 글
| VLOOKUP (0) | 2023.06.12 |
|---|---|
| Converting data (0) | 2023.06.11 |
| 새로 알게 된 기능 (0) | 2023.05.28 |
| Keyboard Shortcuts for Functions (0) | 2023.05.25 |
| Errors and fixes (0) | 2023.05.25 |
