• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sumifs formula help


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!



Excel Ninja
Do You keep Your the previous thread's the last reply still 'waiting for reply'?
... should You write there that You've opened a new thread?