Good day to all.
I'm working on this dashboard wherein I count items sent each year and by day. My query now was if I have to select my desired year in B2 then the formulas in each cell will automatically change on the name of table same as the year as i selected?
ex. chosen year: 2016
formula in cell: =countifs(_2015[area],c4......
I have attached my sample excel file.
Thank you
I'm working on this dashboard wherein I count items sent each year and by day. My query now was if I have to select my desired year in B2 then the formulas in each cell will automatically change on the name of table same as the year as i selected?
ex. chosen year: 2016
formula in cell: =countifs(_2015[area],c4......
I have attached my sample excel file.
Thank you