Forum Discussion
Solved
Totalling money in categories and sub-categories across multiple columns
Hi Community I am trying to wrangle a large income dataset for an organisation in Australia. I have a large spreadsheet that has multiple text categories whose value is tied to a $ amount. Not all ...
In the attached file the categories are text values (left aligned) and the allocated $ are numbers (right aligned).
=SUM(IF($B$2:$F$9=B12,$C$2:$G$9))This formula works in my sample file. The formula must be entered as an arrayformula with ctrl+shift+enter if someone works with legacy Excel such as Excel 2013.
Can you provide an example of the expected result(s) for the sample data, with an explanation?
Totals for all funding categories across all projects:
Funding categories: 10, 15, 22, 25, 30
For the above example:
Category 10: $1664000
Category 15: $10030
Category 22: $154526
Category 25: $14600
Category 30: $81500
