Percentage of certain type of hours submitted



I'm looking to get a percentage of the total number of hours submitted for a certain category from a drop down list within a time frame.

In column A is the date of the submission, column B is the category (e.g. Internal Meetings, HR, General Admin etc.) and Column C is the amount of hours submitted.

I would like to be able to break down the different categories by percentage to feed into a different sheet, could someone advise which formulas I should be using to get the percentage of hours submitted between August and December that were 'Internal Meetings' for example.

Hopefully that makes some sense and any help is greatly appreciated!


  • Frank Falco
    Frank Falco ✭✭✭✭✭✭


    =SUMIFS([ColC]:[ColC],[ColA]:[ColA],>=Date(2019,8,1),[ColA]:[ColA],<=Date(2019,12,31),[ColB]:[ColB],"Internal Meetings")/SUM(([ColC]:[ColC])

    ✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It 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!