The SUMIFS function adds numbers if data meets multiple conditions. Use it to add if:
Numbers are equal to, greater than, less than
Before, on, or after a date/time
Contains a certain word
Webpage: https://sheetshelp.com/sumifs/
Timestamps:
0:00 Intro
1:21 Greater than an Amount and matches a word
3:33 After a date and matches a word
4:15 Before a date and matches a word
5:39 Match part of the text using a wildcard and then a whole word
6:49 Only one condition - SUMIF
Next video | Named Ranges • Google Sheets - Use Named Ranges to S...
#googlesheets #spreadsheet #sumifs