Cristina_Fitzgerald

Jan 02, 2023Copper 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 c...

- Jan 02, 2023
`=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.