Sunday, June 9, 2013

yogi_Count Instances When Column A Equals 'Xing/Deutsch' And Column B Equals 'wait for reply' Or 'DONE'

                                          Google Spreadsheet   Post  #1233
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun 09, 2013
user Robert Bornemann (http://productforums.google.com/forum/?zx=bedk0wbux5gu#!mydiscussions/docs/EIEAjahSDZU)
Count Criteria A if "B" or "C" is true?
Dear Community -  I have a question,

I have found a bunch of different contributions to this theme but nothing that helped me in this particular case.

I'd like to countif a criteria when 2 other criteria in another column are true. In example: the number of criteria "xing/deutsch" if I have either "waiting for answer" in the same row Column M or "DONE" in the same row Column M.

I tried this but it doesn't work -->

=ArrayFormula( SUM( ('SUMMARY/Round 1'! I1:I100= "xing/deutsch " ) * (('SUMMARY/Round 1'! M1:M100 = "waiting for answer" ) + ('SUMMARY/Round 1'! M1:M100 ="DONE"))))

can anyone help?

Thanks a lot
---
Hey Yogi,

first of all: Thx for the quick reply - I read a lot of you contributions in this forum and I think its great.

I created this Sample in order to demonstrate my problem. I want to count the number of "xing/deutsch" if either "DONE" or "waiting for answer" is true in the same row. The Data is located in Sheet1 and the results in Sheet2.


Would be awesome if you or anyone else could help. Just started to get my head around different google spreadsheets formulas.

cheers

Rob
-----------------------------------------------------------------------------------------------------------------------