Morning All,
This is my first post, so please bear with me if I have to ask multiple questions.
I am looking to create a dashboard that updates with each cell entry (Live updates). I have a single spreadsheet from which to gather the data, but there will be 52 tabs (1 per week for a whole year), from which the data will be gathered
I have assumed that to start this off it would be best to gather all the information I need and collate this onto a separate tab, then use this tab to create the dashboard.
The trouble I have is that although I can count the number of drops done by each driver from a single spread sheet using the following formula =COUNTIF('Week 1'!E5:AA127, "allan") I cannot manage to then get additional data from the other tabs I have created.
I then tried the following formula =SUMPRODUCT(COUNTIF(INDIRECT({"'WEEK1'!D5:AA127";"'WEEK2'!D5:AA127";"'WEEK3'!D5:AA127"}),A12)), but I cannot get this to work?
I would like to show the quantity of drops done by each driver, and how many times we go to each area, both on a daily basis. There are other things I would like to show, but I would like to get the basics done first then I can work on the rest, as this would help me develop an understanding on how excel works?
Any help to push me in the right direction, would be appreciated.
Bookmarks