Dear Experts, please find here attached sample workbook where i have set few criteria and based on the same i am trying to use a formula but it is not giving the correct output in the Report tab at Cell B7.

Request to you kindly help me out.

Many thanks and kind regards,

Neilesh

Sample workbook.xlsx