New answers tagged javascript
1
vote
Accepted
How do I "=SUMIF" or "=COUNTIF" functions with multiple conditions from different column's?
Use filter(), like this:
=sum( iferror( filter( O24:O, left(N24:N) = "W", (K24:K = 445) + (K24:K = 450) ) ) )
When the values in column K are not numbers but text strings that look like ...
- 6,503
Top 50 recent answers are included