Forum Discussion
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.