The COUNTIFS function is used in Google Sheets to count cells if their data meets certain conditions. Let's run through several examples to see how this function works.
Webpage: https://sheetshelp.com/countifs/
Timestamps:
0:00 Values between two amounts
1:56 Between two dates
4:50 Matches a word and is greater than an amount
6:14 Is TRUE and contains a word
7:00 Doesn't contain certain text and is less than a number
7:59 Only one criterion - COUNTIF
Next video | Named Ranges • Google Sheets - Use Named Ranges to Simpli...
#googlesheets #spreadsheet #countifs