SOLVED

# Excel formatting

Copper Contributor

# Excel formatting

I have a spreadsheet that lists events with a \$ value in the cell to the right. Spreadsheet has multiple columns with same events. Each event is color coded. How do I group each event and total the cell next to it? This is a spreadsheet that lists companies and what they sponsored so goal is to know how much \$ we have for each event. See attached pic of spreadsheet. T

2 Replies
best response confirmed by Cristina_Fitzgerald (Copper Contributor)
Solution

# Re: Excel formatting

``=SUM(IF(\$B\$2:\$F\$17=C20,\$C\$2:\$G\$17))``

You can try this formula in order to sum the amounts for each event. Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021.

# Re: Excel formatting

THANK YOU! It took me a bit to manipulate it but this did it. Thank you so much!!!
1 best response

Accepted Solutions
best response confirmed by Cristina_Fitzgerald (Copper Contributor)
Solution

# Re: Excel formatting

``=SUM(IF(\$B\$2:\$F\$17=C20,\$C\$2:\$G\$17))``

You can try this formula in order to sum the amounts for each event. Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021.