Forum Discussion

GreenAnalyst's avatar
GreenAnalyst
Copper Contributor
Sep 02, 2025

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 Projects receive every category of funding, so some blanks exist.

The categories are treated as text.

So for this example, I need to be able to get the total Funding $ amount for Research Category 10, across Category 1, 2, and 3.

I have hundreds of rows set up like this:

How do I get the total funding amount of each research category in my table? I have literally hundreds of rows set up like this. 

Project Name Research Category 1 $ allocated to Cat 1Funding Category 2$ allocated to Cat 2Funding Category 3$ allocated to Cat 3

Cat research

10$400015$100  
Dog research20$5000022$300010$5000
Car research25$900030$8000022$1000
Table research30$150010$1500000  
Food research10$15000020$486115$3000
Engineering research15$600010$5000  
Flag research25$560030$800015$800
Dust research20$9966515$130  

2 Replies

Resources