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.

https://docs.google.com/a/wimdu.com/spreadsheet/ccc?key=0AuckjVqhZnsudGZrWG5GSzZXdGtMampGWVNTdGNERlE#gid=1

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

cheers

Rob

-----------------------------------------------------------------------------------------------------------------------