Sum for filtered cells

[Bakar]

Hi Everyone
Can I have an idea how to get the sum of filtered cells only
Example I filter arange of cells containing MONDAY in Range A
and in range B there are different values can I have only the sum for Monday:

[NBVC]

Use Subtotal()

e.g.

=SUBTOTAL(9,A1:A100)

[Bakar]

Use Subtotal()

e.g.

=SUBTOTAL(9,A1:A100)

Thanks Its working good

Bakar

[Bakar]

Thanks its working good