SUMIFS function in Google Spreadsheet

by

The simplest way to easily make SumIFS-like functions in my opinion is to combine the FILTER and SUM function.

SUM(FILTER(sourceArray, arrayCondition_1, arrayCondition_2, ..., arrayCondition_30))

For example: 

SUM(FILTER(A1:A10;A1:A10>5;B1:B10=1)

Explanation: the FILTER() filters the rows in A1:A10 where A1:A10 > 5 and B1:B10 = 1. Then SUM() sums the values of those cells.

This approach is very flexible and easily allows for making COUNTIFS() functions for example as well (just use COUNT() instead of SUM()).

More Related Contents:

  1. Faster way to find the first empty row in a Google Sheet column
  2. Best Practices for Multiple OnEdit Functions
  3. How many CPU cycles are needed for each assembly instruction?
  4. Google app script timeout ~ 5 minutes?
  5. What is the best approach to encapsulate blocking I/O in future-rs?
  6. Why does breaking the “output dependency” of LZCNT matter?
  7. nth fibonacci number in sublinear time
  8. Comparing BSXFUN and REPMAT
  9. ArrayFormula of Average on Infinite Truly Dynamic Range in Google Sheets
  10. Timing JavaFX Canvas Application
  11. What’s the fastest way to merge/join data.frames in R?
  12. How to optimize vlookup for high search count ? (alternatives to VLOOKUP)
  13. What is the fastest way to get the value of π?
  14. Fast query runs slow in SSRS
  15. Entity Framework query slow, but same SQL in SqlQuery is fast
  16. Bulk inserts taking longer than expected using Dapper
  17. Why are compilers so stupid?
  18. SVN performance after many revisions
  19. How slow (how many cycles) is calculating a square root?
  20. Mapping 2 vectors – help to vectorize
  21. Query is ignoring string (non numeric) value
  22. How to compare dates or date against today with query on google sheets?
  23. Should a developer aim for readability or performance first? [closed]
  24. Ways to improve git status performance
  25. MongoDB ranged pagination
  26. why is data structure alignment important for performance?
  27. Benchmarking – How to count number of instructions sent to CPU to find consumed MIPS
  28. How can Google be so fast?
  29. Range() VS Cells() – run times
  30. Performance of bcp/BULK INSERT vs. Table-Valued Parameters

Leave a Comment