# Calculation Formula Help

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.

• 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 😊

• 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 😊