Data should change with multiple month selection

[trprasad78]

Hi

I have attached file, it have 2 sheets "Expenses" & "Sales".

using sumifs() function i able to get Margin for each business person by month.

But I would like to know any way , what are the possibility to select multiple month based on that result has to change.

Kindly help me.

Thanks,
Prasad

 

[NARAYANK991]

Hi Prasad ,

How are you going to have multiple months selected in K9 ?

Narayan

 

[trprasad78]

Hi Prasad ,

How are you going to have multiple months selected in K9 ?

Narayan

Hi
That's my question, if any other method please suggest.

If can we do using pivot table ? if so how?

any other method also please suggest.

final out put should be sum of sales , sum of expenses and margin.

Regards,
Prasad

 

[NARAYANK991]

Hi Prasad ,

See this file.

Narayan