Calculation Formula Help

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

Best Answer

  • ro.fei
    ro.fei ✭✭✭✭✭
    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

  • ro.fei
    ro.fei ✭✭✭✭✭
    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!

  • tmichelle068
    tmichelle068 ✭✭✭✭

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

  • ro.fei
    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 😊

    βœ… 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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!