Monday, June 30, 2014

yogi_Do Multi-Conditional Count In Google Old Sheets

                                        Google Spreadsheet   Post  #1685
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun-29-2014
post by : Sin Chan: (https://productforums.google.com/forum/#!mydiscussions/docs/4Z33LbUCCl0)
How to write countifs

there is no countifs in google sheet. I look online on how to write arrayformula but it isn't working.

In excel, my formula work =COUNTIFS($E14:$E170,"Critical",G14:G170,"MET")  

Anyone can help me to write the same formula in google sheet? I have 2 rows. I am counting row E with "critical" and rpw G with "MET" or "NOT MET". I will count separately on critical with met and critical with not met. 

Thanks!

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