iamanexcelnoob
Board Regular
- Joined
- Jun 15, 2016
- Messages
- 71
hi all, i am looking to analyze a large set of data and to do so have developed a sort of basic dashboard.
in said dashboard, there is a dropdown (data validation list) with a month name that corresponds to the data set i am analyzing and in which the months are listed horizontally across the x axis.
i want to sum these columns based on one or two criteria in other columns of the data set.
for visual reference, let's say my data set looks as such:
<tbody>
</tbody>
and my dashboard looks like the below with a dropdown box above for the month:
<tbody>
</tbody>
thanks in advance for any and all assistance!
in said dashboard, there is a dropdown (data validation list) with a month name that corresponds to the data set i am analyzing and in which the months are listed horizontally across the x axis.
i want to sum these columns based on one or two criteria in other columns of the data set.
for visual reference, let's say my data set looks as such:
Product | Jan | Feb | Mar | Apr |
Orange | 1 | 2 | 3 | 1 |
Pear | 2 | 3 | 1 | 2 |
Orange | 1 | 4 | 1 | 3 |
Pear | 2 | 3 | 2 | 1 |
Apple | 2 | 4 | 1 | 3 |
Apple | 3 | 2 | 3 | 1 |
Orange | 4 | 2 | 1 | 2 |
Pear | 2 | 1 | 4 | 1 |
Orange | 1 | 3 | 0 | 1 |
<tbody>
</tbody>
and my dashboard looks like the below with a dropdown box above for the month:
Product | Total (based on dropdown) |
Apple | |
Orange | |
Pear |
<tbody>
</tbody>
thanks in advance for any and all assistance!
Last edited: