Sumif 1 of 2 criteria is met

[bluetacos]

Hi,

I'm having troubles turning this Excel formula:

Please Login or Register  to view this content.

into this VBA code:

Please Login or Register  to view this content.

The problem lies with the {} braces; vba doesn't recognize them. The formula needs to sum a range if the adjacent left cells equal 110.50 or 110.60.

I could use sumproduct:

Please Login or Register  to view this content.

but once again the {} are used. Any ideas on how I can get around using {} within VBA? I'm not sure if evaluate will work since the range will be changed thousands of times using a variable within .Cells(variable, 2).

Thank you!

[venkatpvc]

try this

Please Login or Register  to view this content.

[bluetacos]

I need to be able to change the SUMIF range using a variable, hence why I was trying to use

Please Login or Register  to view this content.

With your formula is there a way I can change "B3:B25" with a variable? I have a loop that will go through thousands of cell combinations. I thought about using DSUM, but many of the loop iterations will only use a portion of the input cells (in the middle of the range) leaving me unable to select any type of headers. Please correct me in any sense I'm wrong.

Thanks