Need excel formula help

fixer

I'm In My Prime
Joined
Jan 28, 2010
Messages
2,060
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 B2:p59

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

=SUMIF(B2:p59, S4, OFFSET(0,-1,))
 

fixer

I'm In My Prime
Joined
Jan 28, 2010
Messages
2,060
I got it..
Code:
=SUMIF($D$5:$P$58,S4,$C$5:$O$58)
 

Joel R

Fan
Joined
Nov 24, 2013
Messages
775
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

Administrator
Joined
Jan 2, 2020
Messages
47
I love Excel. I feel it and Google Sheets are undervalued.
 

Joel R

Fan
Joined
Nov 24, 2013
Messages
775
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.
 
Top