Wednesday, September 19, 2012

yogi_Count If Entity is Group 1 And Status Is New or In Progress

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #761   Sep 19, 2012

user Jacksonl said: (!category-topic/docs/spreadsheets/oCThJ5EZiM4)
Complicated COUNTIF?

I have a spreadsheet that is essentially a todo list for different groups. I have a column for Group and Status. Both have data validation drop downs. 

I have easily been able to use a simple COUNTIF to count up the total incomplete tasks: the F column is my Status column.

=COUNTIF(F7:F100, "New") + COUNTIF(F7:F100, "In Progress")

Now I would like to have a similar count, but it should be specific to the group. "Count all rows where that have the Value, "Group 1" in Column D and have the values "New" or "In Progress" in column F.

Here it is in c-ish pseduocode:

int n = 0;
if ((F7:F100, "New") OR (F7:F100, "In Progress")) AND (D7:D100, "Group 1")
following is a solution to the problem