calculate Standard deviation with three criteria

Hi everyone,

I want to calculate standard deviation if it satisfy three criteria:

If E2:E500=104 and B2:B500>=G12 and B2:B500<G13 then calculate standard deviation for C2:C500.


Explanation:
E2:E500 having different numbers(102,102,103,103,104,104,104) = 104(first condition)
B2:B500 having different dates(11/02/2022,11/02/2022,12/02/2022,12/02/2022,13/02/2022,13/02/2022,13/02/2022) and G12 have one date(12/02/2022)(Second condition)
B2:B500 having different dates(11/02/2022,11/02/2022,12/02/2022,12/02/2022,13/02/2022,13/02/2022,13/02/2022) and G13(13/02/2022) have another date(third condition)

all three must be inculcate to calculate standard deviation for C2:C500.

please help to write formula for this criteria.

Thanks & regards

Thanks!
its works!