Unfortunately, SUMIF alone will not work for me, as my "criterion" is not in a single column.
I'd need like four different formulas if I wanted to only sum those cells to the right of "Cost."
e.g. -- =SUMIF(A:A,"cost",B:B)+SUMIF(B:B,"cost",C:C)+SUMIF(C:C,"cost",D:D)+SUMIF(D:D,"cost",E:E)
But given the size of my spreadsheet, that's not going to work.
Seems I need a formula which will search for "Cost" everywhere, and then sum only the cell to the right of that cell.
Any other ideas?