Countif with Indirect formula help

[Neilesh Kumar]

Dear Experts, I got stuck once again and looking for your precious support. I have tried with countif formula but not succeeded. Please find here attached sample workbook where i have mentioned the expected results for a sales person monthwise.

I do have a situation where i need to count the numbers of the customers Newly added for the month and how many out of them got removed in the month from their sales pipeline.

For Jan month if the Customer name is disappeared from Feb then that would be counted as 1Qty that will be appeared in cell B3 Report tab under customer removed from the pipeline and that particular removed customer deal value will be appeared in Cell C3 Report tab.

I am looking my expected results in Report tab from Cell B2:C4 based on the Selected Sales Person from the dropdown and the output will be coming from Master tab.

For eg. Sales person ABC in the Master tab there are only 3 customer have been removed from Feb-18 which was added in Jan-18 so the Qty for Removed customer would be 3 in cell B3 Report tab and deal value for those 3 customers which got removed from Feb-18 pipeline will be appeared in cell C3 Report tab and the same criteria would also be applicable for the upcoming months.

I hope i have explained everything what i am looking for. Please feel free to revert back in case of further clarification.

Many thanks and kind regards,

Neilesh


Dear Experts i do apologies for making the changes in the expected results and accordingly i have mentioned above now everything finally my expectations. Please find here attached revised sample workbook.

Once again apologies