94mustang
Board Regular
- Joined
- Dec 13, 2011
- Messages
- 133
- Office Version
- 365
- 2019
- Platform
- Windows
Excel Worksheet Function Experts,
The table below is an example of what I am trying to COUNT. When a single project (Project1 below) has a Work Item that is “Process Complete” AND Proj Status is “Completed” AND Work Item is “Logo Returned” AND Proj Status for the Logo Returned is “Canceled” OR “Completed”, how do I get it to count as a single value of 1? Other Software is generating this table of data and I need to use one or multiple functions to develop a table that will provide a total number of projects that have been completely manufactured. In other words, when I have the conditions in blue text met for a single project, I would like to count this as a value of 1 so the formula will total the number of projects. Project3 is another example but may not have the “Canceled” portion for Logo Returned in the Proj Status column. Any help would certainly be greatly appreciated.
Can this formula be made into one cell to calculate a total? I would prefer not to have a formula in every cell next to the row if at all possible. However, if formulas are needed on every row, I am okay with that too.
<TBODY>
</TBODY><o></o>
The table below is an example of what I am trying to COUNT. When a single project (Project1 below) has a Work Item that is “Process Complete” AND Proj Status is “Completed” AND Work Item is “Logo Returned” AND Proj Status for the Logo Returned is “Canceled” OR “Completed”, how do I get it to count as a single value of 1? Other Software is generating this table of data and I need to use one or multiple functions to develop a table that will provide a total number of projects that have been completely manufactured. In other words, when I have the conditions in blue text met for a single project, I would like to count this as a value of 1 so the formula will total the number of projects. Project3 is another example but may not have the “Canceled” portion for Logo Returned in the Proj Status column. Any help would certainly be greatly appreciated.
Can this formula be made into one cell to calculate a total? I would prefer not to have a formula in every cell next to the row if at all possible. However, if formulas are needed on every row, I am okay with that too.
Proj Name<o></o> | Work Item<o></o> | Proj Status<o></o> |
Project1<o></o> | Process Complete<o></o> | Completed<o></o> |
Project2<o></o> | Shipped<o></o> | Cancelled<o></o> |
Project3<o></o> | Logo Returned<o></o> | Completed<o></o> |
Project2<o></o> | Issued<o></o> | Not Started<o></o> |
Project3<o></o> | Process Complete<o></o> | Completed<o></o> |
Project1<o></o> | Logo Returned<o></o> | Canceled<o></o> |
Project1<o></o> | Logo Returned<o></o> | Completed<o></o> |
<TBODY>
</TBODY>
Last edited: