Calculation Formula Help

tmichelle068

Hi all! Here is a snip of the columns on a separate sheet that I am referencing in my formula:

I need to count how many times a survey is completed each month in each area. I have a total submissions section where the total number of submissions is a rolling count, but I need to drill that down to show, for instance, how many times A2 completed a survey in January 2023. I thought I could use a sum or count formula, but I can't make it work in my head.

ro.fei

Hey @tmichelle068

You'll want to use a COUNTIFS formula for this, listing multiple conditions.

To use your example, you could have something like:

= COUNTIFS({Area Surveyed:}, = "A2", {Month Completed}, = "January")

This is just a sample of the form it would take; the ranges will refer to the columns in your reference sheet, & the criterion will be next to their respective column references. With COUNTIFS you can list as many ranges/criterion as you need.

Let me know if you need more help! I hope this was useful 😊

ro.fei

Hey @tmichelle068

You'll want to use a COUNTIFS formula for this, listing multiple conditions.

To use your example, you could have something like:

= COUNTIFS({Area Surveyed:}, = "A2", {Month Completed}, = "January")

This is just a sample of the form it would take; the ranges will refer to the columns in your reference sheet, & the criterion will be next to their respective column references. With COUNTIFS you can list as many ranges/criterion as you need.

Let me know if you need more help! I hope this was useful 😊

tmichelle068

Wow I was making that WAY harder than it needed to be in my head HAHA! Thank you so much!

ro.fei

@tmichelle068 Happy to help! Feel free to mention me if you need more help in the future, I do this kind of thing all the time 😊