Or did you use index and sumifs?

@@carrencelor6829 coming back soon… with Looker Studio videos 🙌🏻

Regarding the alternative row header issue ….In what part of the video are you referring to? Can you provide the timestamp for reference? Just want to make sure I’m not missing anything. Thanks!

​@@JP-dy3ge DATE RANGE ISSUE (filtering the wrong range) 45:00 you add the dates via validation for Start Month and End Month using data from I2:I form your dropdown sheet (unecessarily pulled from P2:P of Sales). That data is the 1st day of the month. You need to add a column in Sales Data v2 for MonthEnd in Col Q that gets the last day of the month to use for validation on End Month. I assume you want that to be 3/30 or 7/31 (the last day). With your current "between dates" query if you select Jan 2024 (start) and Mar 2024 (end), it's only querying transactions from 1/1 to 3/1, NOT 1/1 to 3/31 as it should. As an aside on those formulas You should make them dynamic and not dependent on copying the data down to each cell. Put this in P1 and Q1 on Sales Data v2 ={"MonthStart";arrayformula(if(A2:A="","",EOMONTH(A2:A,-1) + 1))} ---- this is the 1st day of the month in A ={"MonthEnd";arrayformula(if(A2:A="","",EOMONTH(A2:A,0)))} ---- this is the last day of the month in A Also for the data validation you don't need to make the additional sort-unique on the dropdown tab, just data validate P2:P for Start and Q2:Q for the End directly from your sales sheet. Data validation natively return as a unique and sorted list of any column data. If you want all dropdowns on the same sheet for readability or to keep track, then query the entire start and end columns there, no need for Sort(Unique()) You can use these type of arrays in any cell where you want the formatting to carry to the columns below. Benefit of this method is that you can sort, reorder, insert/delete rows and the arrayformula is automatically applied. No more rows with missing formulas. Also, it's way less memory intensive. (I dropped that formula in ChatGTP and put the results at the bottom of the message... ALTERNATING COLORS 1:00 If you want a header that is you own color (you have blue background and white font) and the rows below (G2:G) to alternate gray/white, you manually color G1 to your header colors, then set your "Apply to Range" under alternating colors to G2:G and uncheck the HEADER box. ChatGPT Explain this... ={"MonthEnd";arrayformula(if(A2:A="","",EOMONTH(A2:A,0)))} Answer: This formula is used in Google Sheets to calculate the end of the month for each date listed in column A and automatically expand the results down the column. Let’s break it down: ={"MonthEnd"; This creates a header for the column. The text "MonthEnd" is placed as the title of the column in the first row where this formula is entered. arrayformula( The ARRAYFORMULA function allows operations to be applied to entire ranges, rather than just single cells. It makes the formula dynamic, so it applies the operation to all rows in the range A2:A. if(A2:A="", "", This checks if the corresponding cell in column A is empty. If it's empty, it leaves the cell blank (""). This ensures that the formula doesn't calculate for rows without data. EOMONTH(A2:A, 0)) The EOMONTH function calculates the last day of the month for a given date. A2:A specifies the range of dates. 0 specifies that it calculates the end of the current month (not offset by additional months). Summary If a date is entered in column A starting from A2, the formula will calculate the last day of the month for that date and display it in the corresponding row of the column where the formula is placed. If column A is empty, the corresponding cell in the results column remains empty. The formula dynamically applies to all rows in column A as data is added or removed. For example: If A2 contains 2025-01-15, the result will be 2025-01-31 in the results column. If A3 is blank, the results column will also be blank for that row.

@@bayarea13​​⁠- Appreciate the breakdown, all makes sense! I spotted that date error as well and wanted to see if anyone else caught it, and wham there was your comment lol. Are you on LinkedIn? Would love to add you to my network.