• 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

    Hui...

  • 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

blcexcel

blcexcel

Member
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!
 

Attachments

  • Month sum challenge 3.xlsx
    23.8 KB · Views: 7
blcexcel
Do You keep Your the previous thread's the last reply still 'waiting for reply'?

Formula challenge - sum criteria

I need help creating a formula that will take into account criteria on a different tab. I have an example on the attached file. Any help would be appreciated. Thanks in advance!!!
chandoo.org
... should You write there that You've opened a new thread?
 
You must log in or register to reply here.
Back
Top