I'm trying to get a count based on a specific entry in one column AND add the choice made from a separate column in my google sheets. Should I use a different formula than COUNTIF since I have multiple entries to count?
Example: Countif(I:I, "j", "k", "l") Countif(J:J, "SPH", K:K "SPH")
Is there a better way to count more than 3 criterion in a column? if so, could a second count be added to include a separate columns criterion?
CodePudding user response:
You should be using COUNTIFS
COUNTIFS Function helps us get conditional counts within a range based upon multiple criteria’s. It’s a enhanced version of it’s sister function COUNTIF which also gives us conditional counts but only with a single criteria.
= COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])
applied to your criteria:
= COUNTIFS(I:I, "j", I:I, "k", I:I, "l", J:J, "SPH", K:K, "SPH")