Subtotal function limitation

[timetiempo]

Disclaimer I am a novice at excel (so please keep that in mind when replying), the excel version I am using is 2016 64 bit.

I have data that I have assembled into a table, using the advanced filter feature I can identify individuals who fit my criteria. That's great but I need to also know the total hours for each individual not the combined hours of people who fit my criteria.

Currently I have tried using the SUBTOTAL but that's where I am stuck. I have attached an image so you can hopefully see the issue.
The filtered list shows 7 individuals, I want to know the total hours person #1 has completed, person # 2, person # 3, etc.

So I cannot just do =SUBTOTAL (9,F:F) or that's everyone in the filtered list. Please advise an efficient way to proceed as my criteria here fortunately shows 7 people but for another search, a different amount like 50 people will show up.

[GC Excel]

Hi and welcome to the forum.

To me instead of using SUBTOTAL, I would use a Pivot Table.
You will be able to apply all the filter that you want and see the results of all the people you need.

If you never used PivotTables before, you'll be able to find a lot of examples. Just ask your friend Google...

[protonLeah]

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to Quick Post button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!