google-sheetsgoogle-sheets-formula
Google Sheets - Trying to create a SUM of earnings per MONTH & per YEAR
I'm new to all excel google sheet and I was tasked to creat a sheet in which i have a tab/sheet called "Payments" where I record payments from jobs along with other info like date.
I want to create another tab called "Statistics" where I want to SUM all earnings per specific month that is seperate for each year.
I am currently trying to use =ArrayFormula(SUMIF(MONTH(Payments!E2:E500)&YEAR(Payments!F2:F500),"="&MONTH("April")&YEAR("2023"),Payments!H2:H500)), but not sure why this doesn't work out.
Can you please help?
Link to the sheet
Solution
With MakeArray you can navigate through your headers with the help of index and the coordinates. And I used LAMBDA and BYCOL for the totals:
=LAMBDA(arr,{arr;BYCOL(arr,LAMBDA(each,SUM(each)))})(MAKEARRAY(12,COUNTA(B1:G1),LAMBDA(r,c,SUMIFS(Payments!H2:H500,Payments!E2:E500,INDEX(A2:A13,R),Payments!F2:F500,INDEX(B1:G1,c)))))
- Google Sheets formula to remove all punctuation excluding period (.)
- Formula to find missing serial numbers
- Copy Data from one column and past at the end of another column
- Query formula not grouping properly
- Comparing text fields that contain dates in Google Sheets
- regexreplace multiple columns for football data
- I want to use a macro to check a value in a sheet and return one of two values
- How can I remove consecutive duplicates from a range in Google Sheets?
- Using FILTER with multiple conditions on Google Sheet
- How to union ranges in google spreadsheets
- Google Sheets Dynamic Dropdown List Dependent with multiple rows
- Formula for filtering list based off of key with multiple criteria in Google Sheets
- Conditional Dropdowns in Google Sheets Based on Multiple Criteria
- How to use Apps script to move a lot of data rows at same time to different spreadsheet automatically base on time
- How to ignore empty rows when submitting to database
- Custom Menus Google Apps Script
- Google Sheets Index Sidebar of all tabs - add search functionality
- How do I compare new IDs with a column of existing IDs and allowcate a timestamp if two IDs match on Google Sheets?
- Google script Display array with rows of different sizes
- How to Delete Today's Google Calendar Entries in Google Apps Script
- List rows in array when the cell contain number in the string
- ImportXML XPath issue using Google Sheets on a simple web scraping query
- Google Sheets Macro Script to expand column group based on cell value
- Return index of cell that contains match on two strings
- Conditional formatting if cell past date and another cell empty with arrayformula
- How to find the Second Space from the right in Google Sheets?
- Joining more than two WHERE statements in Query Language
- Python gspread create sheet if not exist
- Find if cell contents exist in array
- Google Apps Script: Finding an element in a Column and returning the corresponding row