formula qestion

[TophatPops]

I need help understanding how this formula works =SUBTOTAL(9,C2:C187
This is used for payroll, the sheet has employees with hours worked over a two week period. I have totaled the hours by employee in a separate column and it does not equal the total in C.
Any help will be appreciated!

 

[Michael M]

THe Subtotal function operator number 9 in the formula simply tells the function to sum the range C2:C187
IT WON'T include any other SUBTOTALS that fall within that range

 

[TophatPops]

THe Subtotal function operator number 9 in the formula simply tells the function to sum the range C2:C187
IT WON'T include any other SUBTOTALS that fall within that range

Thank you for you help!

 

[TophatPops]

Thank you Michael M for your help, I appreciate it

 

[Michael M]

Have a look at the link for a list and descriptions of what the SUBTOTAL function can do !!

https://support.office.com/en-us/article/subtotal-function-7b027003-f060-4ade-9040-e478765b9939

 

[TophatPops]

Thanks again Michael!