Percentage of certain type of hours submitted

Jessie Madden

Hi,

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

Try

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