Sheet Summary Help

Kayla Rice

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

@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

@Kayla Rice Great! Glad that worked for you.

Malaina Hudson

@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.

Kayla Rice

Thank you @Malaina Hudson that worked! I was way overthinking

Malaina Hudson

@Kayla Rice Great! Glad that worked for you.