I am looking for the max value in the table's total row. I have the formula that worked before below, but then I added more columns and now it doesn't work. Now I need to only include those headers that do not have "Time" or "Price" in the header.
How would I modify this formula to do that? I have included sample attached.
Currently, my formula is:I want it to exclude a header that has "Time" or "Price" in the header name.Please Login or Register to view this content.
I saw SumProduct can do this when a word is included in the header, but the solution seemed to be different than what I am needing (because it sumed the whole column, and I am trying to exclude columns with words, etc)
I appreciate the advice.
Bookmarks