Sumifs formula that will calculate the sum of multiple criteria

[JGREEN17]

Hello,

Attached is a spreadsheet with 2 tabs at the bottom ("Solex" and "Summary"). In the Summary tab, I wrote a formula in Columns E:G that will sum up the Dollars of certain Columns in the Solex tabs that have the same Column Header Name that are in Columns E:G of the Summary tab. For example: One Name of the Column Header is "E-Regular - WK1" The problem with my formula is that it is column specific in the Solex Tab, meaning that if the Column changed from "W" to "X" then I would not get the sum of the data that I want it to sum. I hope I explained this properly. I'm still fairly new with excel so any help with rewriting these formulas would be appreciated.

Recap : Summary tab should have a formula that will sum the dollars based on the "Header Name" of the column on the Summary Tab, and then the "Store Name", and then the "Check Date."

Thank You in advance for any and all time spent on helping me with my issue.

Jason

[AliGW]

Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
  
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.

[JGREEN17]

I changed the title. Will forum users be able to reply to my post now? Is there something you can do so my post can be replied to?

[FlameRetired]

Your headers don't all match. In the attached I changed 'Summary' A3 to "Department".

The rest of the formulas use INDEX/MATCH to define target columns by header.

In E4 and down.

Please Login or Register  to view this content.

In F4 and down and across column G.

Please Login or Register  to view this content.

[JGREEN17]

It worked perfectly. Thank You so much for your help with this. I greatly appreciate it. I will submit this thread as resolved and add to your reputation. Thank You again.

[FlameRetired]

Thank you. It's a pleasure to help.