Countifs with Multiple Criteria in Same Range in Google Sheets
https://infoinspired.com/google-docs/spreadsheet/countifs-with-multiple-criteria-in-same-range/
WEBJan 31, 2018 · First, let’s see the use of the COUNTIFS formula in Excel. Then we can see how to use Countifs with multiple criteria in the same range in Google Sheets. Formula 1: =SUM(COUNTIFS(A:A,TODAY(),B:B,{"APPLE","ORANGE","POMEGRANATES"})) In Excel, it’s quite easy. Excel accepts the OR condition inside curly braces as above.
DA: 58 PA: 75 MOZ Rank: 56