Hi Everyone!
I need help!
I have two worksheets. One is named Dashboard the other is Issues.
In the Dashboard there is a table somewhat looking like this:
Excel 1 Pictures, Excel 1 Images, Excel 1 Photos, Excel 1 Videos - Image - TinyPic - Free Image Hosting, Photo Sharing & Video Hosting
On the next sheet (also named "Issues") I have a table,with two columns we are going to focus on. One column is again "Project name with Project 1, Project 2, etc. BUT the thing is Project 1 might have more than one Issue, so these project names will get repeated. (Ex. Issue 1.1, Issue 1.2 etc) In the other important column, we have its "Status" as either "Open" or "Closed".
http://tinypic.com/view.php?pic=fvw75e&s=9#.WA9W0fl97IU
Sooo, what I would like would happen is that whenever I enter a project along with its issue on the "Issues" sheet table AND its marked "Open",(thats the multiple criteria) the Dashboard sheet "issues" column on the table should be updated and keeping a count of how many issues per project are open...
I could get it to work using the COUNTIFS formula, I am just wondering if there could be a more elegant way to get this to happen.. elegant meaning without the use of helper cells, like I have to have when I use the COUNTIFs method.
So, for clarification, on the "issues" sheet table, the sensitive columns are going to be "Project Name" and "Status". So, its basically a count of how many issues per project is open!
And here is a picture of the helper cells when I use "COUNTIFS" formula. I then link the little cell that gets updated with the corresponding cell in the Dashboard sheet. For example: C15 of "Issues" sheet with C4 of the dashboard sheet.
http://i67.tinypic.com/2mfnur.png[/IMG]
Also another things with the COUNTIFs method is that for any new project I will have to write a new COUNTIF formula. Can there be a way where I just enter the new project name on the dashboard, then the issue sheet updates with the new project and everytime I enter a issue for the new project including any other project then the dashboard gets updated too? Something like that?
I am not very good at these things at all. Would VLookUp work for this? I am not very sure what it is, but it keeps popping up.
kindly go to the links to check out the images. For the 2nd and 3rd images you will have to copy paste the link in your browser. *sigh*
If anyone can help me, I'd be so grateful.
I need help!
I have two worksheets. One is named Dashboard the other is Issues.
In the Dashboard there is a table somewhat looking like this:
Excel 1 Pictures, Excel 1 Images, Excel 1 Photos, Excel 1 Videos - Image - TinyPic - Free Image Hosting, Photo Sharing & Video Hosting
On the next sheet (also named "Issues") I have a table,with two columns we are going to focus on. One column is again "Project name with Project 1, Project 2, etc. BUT the thing is Project 1 might have more than one Issue, so these project names will get repeated. (Ex. Issue 1.1, Issue 1.2 etc) In the other important column, we have its "Status" as either "Open" or "Closed".
http://tinypic.com/view.php?pic=fvw75e&s=9#.WA9W0fl97IU
Sooo, what I would like would happen is that whenever I enter a project along with its issue on the "Issues" sheet table AND its marked "Open",(thats the multiple criteria) the Dashboard sheet "issues" column on the table should be updated and keeping a count of how many issues per project are open...
I could get it to work using the COUNTIFS formula, I am just wondering if there could be a more elegant way to get this to happen.. elegant meaning without the use of helper cells, like I have to have when I use the COUNTIFs method.
So, for clarification, on the "issues" sheet table, the sensitive columns are going to be "Project Name" and "Status". So, its basically a count of how many issues per project is open!
And here is a picture of the helper cells when I use "COUNTIFS" formula. I then link the little cell that gets updated with the corresponding cell in the Dashboard sheet. For example: C15 of "Issues" sheet with C4 of the dashboard sheet.
http://i67.tinypic.com/2mfnur.png[/IMG]
Also another things with the COUNTIFs method is that for any new project I will have to write a new COUNTIF formula. Can there be a way where I just enter the new project name on the dashboard, then the issue sheet updates with the new project and everytime I enter a issue for the new project including any other project then the dashboard gets updated too? Something like that?
I am not very good at these things at all. Would VLookUp work for this? I am not very sure what it is, but it keeps popping up.
kindly go to the links to check out the images. For the 2nd and 3rd images you will have to copy paste the link in your browser. *sigh*
If anyone can help me, I'd be so grateful.
