New answers tagged

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 ...
user avatar
  • 6,503

Top 50 recent answers are included