I have been working on the formula on the attached file, template tab cell Q5. The formula is working but it references month numbers in row 5 and I would like it to reference "X"s instead. The idea is for users to enter an "X" for the columns that apply. I could convert the "X"s to numbers but there will be about 50 columns and the spreadsheet already has 450 columns so I would rather not have another 50 columns converting the "X"s to numbers. Any ideas would be appreciated!
23.8 KB Views: 5