Choosing Column to sum based off criteria in Row/Column in another worksheet

[Joven76]

I am working on a dashboard where I want to sum a particular month's data based off criteria in the dashboard worksheet. In one worksheet I have the product type in one column and a column for each month we expect to recognize revenue. In the dashboard worksheet, I want to specify the month we want to look at and sum the values in the raw data based off the product type.

In the raw data worksheet, the column headers for each month are labeled as 1, 2, 3, 4, etc. The row labels are Sales Dev, Sales Dev Melt, Extrusion, etc. In the Dashboard worksheet I have the row labels and already have a sumif statement that is looking at the specific row label and a specific column.

Please Login or Register  to view this content.

I'd like to be able to choose the month I want to look at based off a value in the dashboard that the user specifies.

I've been playing around with indirect/sumif statements, but haven't been successful. Is there a way to do this with a formula?

If I need to explain further, please let me know.

Thank you in advance for your help.

[AliGW]

Yes, however it would be easier to advise specifically if you attached a sample workbook.

[Joven76]

Trying to attach now. Hope it works.

[Fluff13]

How about
=SUMIF('Backlog Report'!A:A,"Sales Dev",INDEX('Backlog Report'!H7:S214,0,MATCH(MONTH(D6&1),'Backlog Report'!H4:S4,0)))

[Joven76]

That worked perfectly Fluff13. After adding a table and ranges to the workbook and referenced them in the formula, I believe I've accounted for when we add to it rather than setting a specific range of cells and have to go into the formula and change it if we use more than the referenced range.

[Fluff13]

You're welcome & thanks for the feedback