I have the formula below in a spreadsheet I'm working on. I'm using Excel 2010. This statement worked fine when I was total just one column. However, I'd like to modify this to add up multiple columns. I have a row ("E") that contains either "T7" or "T3". If the row is a T3, I'd like to total columns F,G,H, and I. This formula is only summing the first column (F). I've tried this with other columns (J,K,L, and M) with the same result.
Any ideas? I also tried without the absolutes, but that didn't work either.