Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have two columns similar to below:
Status Days Overrun Released 0 Released 5 Planning 0 Build 1 I am trying to count up the number of projects (rows) that are released and have 0 days overrun. I can use COUNTIF to count the number of Days Overrun cells that equal zero. But what I can't seem to do is to only count the Days Overrun items that have been Released based on the cell value right next to it. Does anyone know of a way to do this? It seems similar to a SQL Query WHERE clause but I'm new to using functions in this way. Thank you so much I appreciate it! Christopher |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count unique values and create list based on these values | Excel Worksheet Functions | |||
paste special | values should work with merged cells | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count how many different text values in an array. | Excel Worksheet Functions | |||
Function to list values of last 3 non-blank cells in a vertical bl | Excel Worksheet Functions |