I have a pivot table that has column headers Apples, Oranges, Banannas, Pears, Plumbs. There are values under each of these. I update the pivot table, the headers are ALWAYS in the same row, but in different columns. I want to be able to write a formula that looks at the entire header row, finds Oranges where ever it ends up in the row, and then adds all the numbers listed below oranges. So if Oranges is in D4 and I update the pivot table I might now have it in C4, but I do not want to change my formula that is off to the right.