Hi all,

I have saw plenty of questions similiar to mine and i copied every single code snippet i could and tweeked it but i get the wrong value.

I have 2 worksheets(Raw data & Report). On the 'Report' worksheet which has summarized data i click an option button to filter the 'Raw data' worksheet. It works great! Now with that filter on say column 'BU' i have another column (AW) that has number values (Raw data worksheet).

I need to count those values in column 'AW'(e.g '=30' can have 20 entries) on the Raw Data worksheet and report those numbers on the Report worksheet.

I can get it to count all values =30 but it doesnt respect the filter and counts them all. I tried countif, subtotal, dcount, and looping statement.