Hi All,

I am having an XL file, where I would like to get the subtotal of a particular field based on a condition.

Please find the below sample file.

Where I need the Subtotal (Count) of Records where Name = "A". Please note that the for the region filed, i am having a slicer.

Name Number Region
A 65 South
B 73 North
C 7 West
A 49 South
C 59 South
V 93 North
A 31 West
C 76 East
D 77 East
S 42 North
W 40 North

Regards,
Manoj