Data Dashboard

**Black0ut** · 03-04-2014, 04:06 PM

Hey everyone. I'm struggling to build a dashboard and am looking for some assistance. I've attached a copy of the data I'm working from. What I'm trying to do is show monthly performance based on products of a few different areas. Where I'm running into problems, is with the month listings. If the report shows one month at a time, I can get it to work with SUMIF formulas, however when there is more than one (and there will always be three), I can't figure it out.

Any help would be appreciated.

~B

Excel Forum Sample File.xlsx

**Black0ut** · 03-06-2014, 06:47 PM

Bumping back to the top. Still not able to figure this out on my own after two days of messing with it.

**FDibbins** · 03-06-2014, 07:04 PM

however when there is more than one (and there will always be three)

Yet you only show 2 months?

It would help if you provides some sample answers and data that more closely matched your requirement?

Also, take a look at the sumifS() functions?

**mattbau43** · 03-07-2014, 04:17 PM

There is just not enough information in your workbook for anyone to begin working on this. If you pass along more details like FDibbins mentioned then I would take a look

**AZ-XL** · 03-07-2014, 04:46 PM

Hi
There are 2 functions for each department. Also added helper column in data sheet and changed "Performance Name Criterias" because it have to be same to bring the number.
a1 cell
=IFERROR(INDEX(Data!$C$1:$J$22,MAX(IF(ISERROR(SEARCH(LEFT($A$1,6),Data!$B$1:$B$22)),0,1)*(Dashboard!B$1=Data!$A$1:$A$22)*ROW(Data!$A$1:$A$22)),MATCH(Dashboard!$A2,Data!$C$2:$J$2,0)),"")

a11 cell
=IFERROR(INDEX(Data!$C$1:$J$22,MAX(IF(ISERROR(SEARCH(LEFT($A$11,6),Data!$B$1:$B$22)),0,1)*(Dashboard!B$1=Data!$A$1:$A$22)*ROW(Data!$A$1:$A$22)),MATCH(Dashboard!$A12,Data!$C$2:$J$2,0)),"")

Uploading file