I'm building a dashboard based on this tutorial http://chandoo.org/wp/2008/09/10/kpi-dashboards-graphs-excel/
I am OFFSET'ing both text and numberical values in the Sort KPI column, which I then had to include a SUM(COUNTIF) function in the Unique column to handle both text and numbers.
I am the next phase where I would like customize the dashboard for my needs and pull data (numbers) from two columns from the Data! worksheet but would like to SUM these values in the Sort KPI.
Is there a way to include the SUM function inside the OFFSET function (i.e. OFFSET(SUM)? Basically, I want to only SUM based on a certain condition (i.e. if I select a certain button in the dashboard that would require to values to first be added, then sorted based on this value).
I am OFFSET'ing both text and numberical values in the Sort KPI column, which I then had to include a SUM(COUNTIF) function in the Unique column to handle both text and numbers.
I am the next phase where I would like customize the dashboard for my needs and pull data (numbers) from two columns from the Data! worksheet but would like to SUM these values in the Sort KPI.
Is there a way to include the SUM function inside the OFFSET function (i.e. OFFSET(SUM)? Basically, I want to only SUM based on a certain condition (i.e. if I select a certain button in the dashboard that would require to values to first be added, then sorted based on this value).