Objective: Sum of Object (similar# post) based on Similar Specific Tag (a data validation has been used).

Here is the screenshot:

This is the data after filter and conditions:
[![enter image description here](https://i.stack.imgur.com/XRA62.jpg)](https://i.stack.imgur.com/XRA62.jpg)

This is what the output should be:
[![enter image description here](https://i.stack.imgur.com/o6vEr.jpg)](https://i.stack.imgur.com/o6vEr.jpg)

For Example: So, when "Tag" is selected "Research Investment Banking" the output should be Sum of "# similar posts" that is 10 + 35 + 14 = 59

Since I'm not great with VBA. I was wondering if AutoFilter would work or SumIf?

```
Selection.AutoFilter
Sheets("Raw").Range("$A$1:$E$23").AutoFilter Field:=5, Criteria1:= _
    Region

```

I've written this code: 'filtering data as per Tag

```
Dim Tag As String

Tag = Sheets("Raw").Range("I1")

Range("D2").Select
Selection.AutoFilter
 ActiveSheet.Range("$A$1:$E$23").AutoFilter Field:=4, Criteria1:= _
 Tag

```

But it's missing the previous code which is to filter data based on Selected Region.

```
'filtering data as per region

Dim Region As String

Region = Sheets("Raw").Range("H1")

Range("E2").Select
Selection.AutoFilter
Sheets("Raw").Range("$A$1:$E$23").AutoFilter Field:=5, Criteria1:= _
    Region

```