SumIf with variable ranges

[pearl]

I would like to sum column "E" based on what column "B" says. The range for column E will vary per run.

To sum column E without the Sumif looks like the following and works great.

<font face=Courier New> <SPAN style="color:#00007F">With</SPAN> ActiveCell<br>                    <SPAN style="color:#00007F">Set</SPAN> Rng = Range(.Offset(-mycount + 1), .End(xlUp))<br>                    .Formula = "=SUM(" & Rng.Address(RowAbsolute:=False, _<br>                   ColumnAbsolute:=False) & ")"<br>           <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">With</SPAN></FONT>

How do I change this to a sumif the associated row and column in B <> Exclude?

Thanks you

 

[GlennUK]

I'd imagine it'd be like this:

With ActiveCell
                    Set Rng = Range(.Offset(-mycount + 1), .End(xlUp))
                    Set Rng2 = Rng.Offset(0,-3)
                    .Formula = "=SUMIF(" & _
                   Rng2.Address(RowAbsolute:=False, _
                   ColumnAbsolute:=False) & _
                   ",""<>Exclude""," & _
                   Rng.Address(RowAbsolute:=False, _
                   ColumnAbsolute:=False) & ")"
           End With

 

[pearl]

Thanks!

 

[GlennUK]

My pleasure!