universeamol
New Member
- Joined
- Apr 3, 2010
- Messages
- 23
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.
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.