Sheet Summary Help

Question

I think this is probably an easy thing that I am overthinking, but I cannot get the Sheet Summary Formula to work. I need to create a formula to count how many Biltmore Site Home, Biltmore Site Telehealth, Biltmore Site Office, and the same for the other site.

I keep trying iterations of this formula with no success. =COUNTIF(Site:Site, "Biltmore") AND (Condition:Condition, "Home")

See screenshot below.

Thanks,

Kayla

Malaina Hudson · Accepted Answer

@Kayla Rice

If I understand your diagram correctly, you are trying to count the occurrences where the condition Site = Biltmore AND Condition = Home.

For this, you'd use the COUNTIFS function.  COUNTIFS works like COUNTIF, but it measures for more than one criteria.  Try this and see if it works for you.

=COUNTIFS(Site:Site, "Biltmore", Condition:Condition, "Home")

Let me know how that works for you.

Malaina Hudson · Accepted Answer

@Kayla Rice Great!  Glad that worked for you.