arraysgoogle-sheetssumifs
Google Sheets Sumifs two arrays (Month and current year)
On Google Sheets I'm trying to sum all the donations for each month and the current year. I have a donation table with date (1/2/2025) and an amount. On a separate sheet I have a list of the months. (January, February, etc.) Next to each month I would like to total all the donations for that month within the current year.
I can sumif for each month using =sumif(arrayformula(text(Donation[Date],"MMMM")),D2,Donation[Amount]).
I can sumif for current year using =sumif(arrayformula(text(Donation[Date],"YYYY")),YEAR(TODAY()),Donation[Amount])
I've tried sumifs but I can't seem to combine these two parameters where there is a conversion in process for both criteria.
Solution
You may try:
=sumif(index(eomonth(Donation[Date],)),eomonth(D2&1,),Donation[Amount])
- Explode string only once on first occurring newline character
- How to make all array keys the same as their respective value?
- what is the wrong with this javascript function?
- Batch matrix multiplication in numpy
- How to reindex an array after extracted from a larger array?
- How to patch form array in typed angular reactive forms
- Isolate a column of values from an array of objects
- Use an array of words to match and an array of replacements to perform replacements on a string
- Calculate a new column and remove other columns within nested objects of a multidimensional object
- Parse an array of delimited values into a flat, associative array
- Parse a text file into an array of associative arrays by splitting on semicolons then by equals signs
- How to access a deeply nested value in a multidimensional array?
- Loop only retains last item iterated
- How to access the second level values of a 2d array?
- How to use ref mut for an array?
- Why do PHP array examples leave a trailing comma?
- Split each value of a flat array at delimiter and create separate arrays from each half
- Iterate over integer in javascript where each value equals a single digit
- How to see if an object is an array without using reflection?
- How to fill in missing months in an array using javascript
- Group array values by prefix
- Split qualifying colon-space separated strings in an array to form a new associative array
- Isolate a single column of values from an array of objects
- Transpose the data from multiple flat arrays to create an indexed array with associative rows
- Group rows of a 2d array by the year and month values from a year-month column to create subarrays in each group
- Simplify API response payload to a 2d array with standardized second level keys
- How to declare an associative array?
- Group multidimensional data by one column and create subarrays in each group
- How to get unique values from an array of objects in a Map?
- How to access data in an array of objects containing arrays of objects?