Jan 09 2017
01:17 PM
- last edited on
Jul 25 2018
09:23 AM
by
TechCommunityAP
Jan 09 2017
01:17 PM
- last edited on
Jul 25 2018
09:23 AM
by
TechCommunityAP
I can't figure out how to combine the formulas =COUNTIF(B:B,"IHC*")+COUNTIF(B:B,"SS*") and =COUNTIFS(A:A,">1330",A:A,"<1431")
I want to only count the criteria in column A if the criteria in column B is also met.
Thank you,
Jan 09 2017 04:35 PM
Jan 10 2017 04:35 AM
Or bit more compact =SUM(COUNTIFS(B:B,{"SS*";"IHC*"},A:A,">1330",A:A,"<1431"))
Jan 10 2017 11:41 AM
Thank you! I don't understand this one, but it gave me the same result as above!
Jan 10 2017 12:21 PM
Anna, that is the imitation of OR condition. In brief, COUNTIFS on array of conditions also generates an array, after that you just take the sum of it. Like SUM({5,7})=12