Monday, July 21, 2014

yogi_ Count Instances Where (B2 to B300 = "2000") or (B2 to B300 = "2001") and (C2 to C300 = "BATTLE & COMPETE")

                              Google Spreadsheet   Post  #1703
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul-21-2014
post by PuzzledAgain98:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/NjmTTl_-ICY)
Below is an Excel Formula. Can anyone "translate" to google spreadsheet for me?? Thanks!!
=SUM(COUNTIFS(B2:B300,{"2000","2001"},C2:C300,"BATTLE & COMPETE"))
-----------------------------------------------------------------------------------------------------------