Hi,
I have this columns in my sheets

Project Status col 1 col 2 col 3
1Project in delivery 10.0 20.0 30.0
2Sold Projects 20.0 1,000.0 50.0
2Sold Projects 2,000.0 5,000.0 200.0
3Prospects 30.0 50,000.0 60.0


Could anyone please help to write macro to sum up the value for each column
by project status.

I want in other sheet when i run a macro
Project status col1 col 2 col 3
1Project in delivery 10.0 20.0 30.0
2Sold Projects 2,020.0 6,000.0 250.0
3Prospects 30.0 50,000.0 60.0


Thanks!