Counting Formula based on Two Criteria


#1

I cannot get a “Count if” formula to work. More clear explanation in screenshot below but I will try and summarize it here as well.

I want to count the “Yes” in a column if that row also contains a specific email. But I also don’t want that count to be in a table, just in text (as you will see on screenshot).

Screenshot of what I have tried so far in terms of formulas is below:


#2

You only need one and.

Try swapping the AND in capitals with a comma.


#3

Im still getting zero: Current formula im trying is

[All Students Master].[TRI This Year?].CountIf(And([All Students Master].[CM Email]=“sweir@cuhsd.org”,[All Students Master].[TRI This Year?]=“Yes”))


#4

You could also do filter on table [All studens master].filter(CmEmail = "sweir@cusd.org" and TriThisYear="Yes").count

Also, i see that you are trying to create a summary on top - you could create another view with cm email setup as a group to see only count - that way you would not have to write formula for every new cm email.


#5

THat worked @Krunal_Sheth! Thank you for the tips