1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Summarizing data by row and column headers

I am looking for a single in-sheet non-VBA formula solution to summarize values by row and column labels.

I am familiar with SUMIFs but this formula does not appear to be able to handle this use case. I can solve this with the likes of HSTACK but that still involves setting up multiple formulas manually within the master HSTACK formula. I am more interested in a formula in which I define the array, column headers, and row headers, and it summarizes appropriately. INDEX and MATCH comes close, in a sense, but it is limited to returning the first matching result rather than summarizing all matching results.

I am using Office 365 desktop. My knowledge is intermediate.

Here is some example data. I will not be working with large data sets.

Original Data

And here is the result I'm looking for (I would provide the row and column headers - the formula would only be expected to return the summarized data into the array)

Desired Result

submitted by /u/mesmerizing_fiasco
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#AI formula generation techniques
#formula generator
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#row zero
#financial modeling with spreadsheets
#natural language processing for spreadsheets
#rows.com
#Excel compatibility
#large dataset processing
#Excel alternatives