Recent content by blcexcel

I added a new thread and got a solution for this. Thanks again for the help!!!

Perfect! Thank you!

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...

Using some tips from everyone I was able to create a formula that is working. There is one improvement I would like to make. Currently the formula will work if month numbers are entered in row 5. This is the row users will enter data. They will be entering "X"s. If I don't get a a solution...

I'll try that. Thanks!!!

If I change the Q28 reference to any other cell the formula doesn't work. This is problematic for converting the formula from this example to my actual spreadsheet. Maybe if you can explain what that reference is doing in the formula. Thanks in advance!

Question on the sumproduct formula. You have a reference to cell Q28 but there is nothing in cell Q28. Should that be a reference to a different cell? Thanks in advance!

I could probably get away with using an array formula. It is not possible to export the data from my system without using cross-tab format. I need to use this particular system for this solution.

Thanks for your response.

I'm running Office 365. This would need to be compatible for Excel 2017. I'm unable to change the data format due to the large amount of data I have and system constraints. I also want to stay away from array formulas because this spreadsheet will be used for a large user population and they...

I attached additional detail on this file.

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

Thanks! I like the tip in the document about adding a menu option to the Quick Access Toolbar. I'm going to go with that option.

I use an Excel Add-in that drops off the menu every time I close Excel. It is very annoying. I would like to create a macro that will add the add-in automatically when I start Excel. Specially it drops the com add-in. The Record Macro doesn't capture the steps of adding the add-in. Any help...

Great tip!