macro with sumif

[orquidea]

Hi:

I want to set a macro which will work with the sumif formula below. The
range (B1:B3 and A1:A3) will be relative every time and would vary the number
of rows subject to be considered. I think I will have to select the range
first with Selection.End(xlDown).Select. But I can not figure out how to
code it.

=SUMIF(B1:B3,20,A1:A3)

Thanks in advance for any help.

Orquidea

 

[Don Guillett]

Pls post in ONE group only. See answers in the other