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.
Best Answer

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 😊
✅ Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. This will make it easier for others to find a solution or help to answer!
Answers

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 😊
✅ Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. This will make it easier for others to find a solution or help to answer!

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

@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 😊
✅ Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. This will make it easier for others to find a solution or help to answer!
Help Article Resources
Categories
Check out the Formula Handbook template!