With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.

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.