I have a spreadsheet created using Table.
I want to subtotal a particular column based on another column text.
e.g. Table1 has a column C, Name of POC, and column J, Status.
Using =SUBTOTAL(103,Table1[Name of POC]), it gives me the total number of Name of POC.
If I want to subtotal the Name of POC based on Column J, status, when it has a text = "Active", How can I change the subtotal formula to meet my requirement? Thanks.
I want to subtotal a particular column based on another column text.
e.g. Table1 has a column C, Name of POC, and column J, Status.
Using =SUBTOTAL(103,Table1[Name of POC]), it gives me the total number of Name of POC.
If I want to subtotal the Name of POC based on Column J, status, when it has a text = "Active", How can I change the subtotal formula to meet my requirement? Thanks.