Help required in sumif function

[universeamol]

Hi,

I have some data of life insurance policies of my clients. I have appointed some agents for sales and i share my commission with them. I have got data with policy number, client name, agent's name, commission etc.

I have to derive a commission for a specific period for an an agent how the formula should be written? with sumif function i could derive the commission for an agent for the entire period. however how to get a specific period commission without applying data filter?

Please help me on this. Thank you.

 

[universeamol]

It worked !! Many thanks...

 

[Akashwani]

Hi,

I'm pleased it worked for you and thanks for the feeback.

Ak