Forum Discussion

Cristina_Fitzgerald's avatar
Cristina_Fitzgerald
Copper Contributor
Jan 02, 2023

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...
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Jan 02, 2023

    Cristina_Fitzgerald 

    =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.

     

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Jan 02, 2023

Cristina_Fitzgerald 

=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.

 

  • Cristina_Fitzgerald's avatar
    Cristina_Fitzgerald
    Copper Contributor
    Jan 02, 2023
    THANK YOU! It took me a bit to manipulate it but this did it. Thank you so much!!!

Resources