No of CVs sent by role and month

Hi all

I’m trying to create a formula to show the number of CVs sent by month and role

So number of CVs for Delivery Managers for October (pic below) is 18 but how I do I get this from a formula?

I can get the number of CVs for all of October using a simple =SUMIF formula but when I trying adding in the role, it breaks!

thanks!


Tags:

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭

    Try:

    =SUMIFS([No of CVs Sent]:[No of CVs Sent], [date sent month count]:[date sent month count],10, [role for reporting]:[role for reporting], "Delivery Manager")

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!