Subtotal Function

[Rhon Alvarez]

Hi Team,

is there any way wherein a function "subtotal" would add data based on a certain criteria?
i.e. to count every TMT with shift starting 5:00 PM as well as HV, CORE and so forth then adds up every time a new shift was selected from the dropdown menu

Pls find attached file.

Thanks in advance for the help.

 

[Chihiro]

Try applying method outlined in the article.
https://chandoo.org/wp/formula-forensics-no-037-how-to-count-and-sum-filtered-tables/

Or the method using helper column:
https://chandoo.org/wp/exclude-hidden-rows-from-totals/

I'm not sure which column that you are trying to add...
It would be helpful if you can generate several example by manually calculating result.