Help in Count if using Option button

[JawaharPrem]

Hi All,

I have get count of executive allocation with FTD (for the day) and MTD(Month till date).

Example 1 - if i select FTD (Option button) i need to get the count of "J" Coloum with i mentioned as"Y",

Example 2 - if i select MTD (Option button) i need to get the total count in base.

Please help on same.

Sample file attached..

Thanks & Regards
Jawahar Prem

 

[Pavan Kumar Sistla]

Hello Prem,

Please see if this works.

Best Regards,
Pavan.

 

[JawaharPrem]

Hi Pavan,

Thanks its working fine...