Need excel formula help

[fixer]

I want to SUM the amount contained in the cells that are 1 column to the left of cells that match S4 content across the range of B259

I think i'm close with this but need some help...

=SUMIF(B259, S4, OFFSET(0,-1,))

 

[fixer]

I got it..

=SUMIF($D$5:$P$58,S4,$C$5:$O$58)

 

[Joel R]

By the way fixer (and you may already know this), you only need the dollar signs $ to fix the absolute positions of the cells, even if you add or subtract new columns and rows.

 

[TLChris]

I love Excel. I feel it and Google Sheets are undervalued.

 

[Joel R]

I love Excel. I feel it and Google Sheets are undervalued.

I'm really starting to dig Google Sheets. I sometimes get tripped up with the menu and settings because it's a bit different than Excel, but I do all of my community analytics in Google Sheets and then save in Google Files.