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 ...
Top 50 recent answers are included
Related Tags
javascript × 91google-sheets × 45
google-apps-script × 44
html × 9
gmail × 8
google-sheets-custom-function × 7
google-forms × 4
google-apps-script-triggers × 4
facebook × 3
twitter × 3
google-apps × 3
google-chrome × 3
keyboard-shortcuts × 3
website × 3
youtube × 2
webapp-rec × 2
blogger × 2
google-analytics × 2
google-sheets-timestamp × 2
google-sites × 2
google-chrome-extensions × 2
time-zone × 2
css × 2
userscripts × 2
jsfiddle × 2