Forum Discussion
Solved
Looking up and summing data in unconventional array
Hello All, Seeking help looking up and summing data located in a single row using a function/formula that can be employed throughout the worksheet in Excel 365. Specifically, my sheet is setup basi...
Detlef_Lewin THANKS for suggesting using SUMIFS. I actually used SUMIF with the optional [sum_range]. The trick was to incorporate the OFFSET function to specify the sum_range. The formula created went like this:
SUMIF(F98:Z98,"FM Pro Rata",(OFFSET(F98:Z98,0,1)))
It looks at Row 98 searching for text FM Pro Rata, then using the OFFSET range on same row (0) and one column right (1) as the sum_range, sums the values from the adjacent cells as they occur along that single row from Col F to Col Z.
- Well THANKS once again! Who knew it would be that easy! Would have saved me a lot of time if there had been an example like my situation in the description of the SUMIF function in Help.