Hi Xld,

Have certain criteria based upon which I need to get the counts excluding the Column C values in Sheet3.

For ex, filter “Retail” in column C of Sheet 1. Then in the column A check for the values and get the count excluding set of values in column C of sheet 3.
On the whole total count is 37 on filtering “Retail” out of which 3 should be excluded and the remaining value should be in the respective column (column F of sheet 3) of sheet 3 (37-3=34)

Attached is the sample spreadsheet for your reference.

-Sindhuja