Sumproduct in VBA
Dave,
I should have been clearer with my last question. I need help with using a
the variable myng in the context of the Sumproduct formula you gave me. If I
simply replace I314:i352 = ""International"" with myrng = ""International"" I
get an error.
Thanks again
"Rafi" wrote:
I would like to implemet the follwoing formula in VBA and would appreciate
any help
The intent is to summ the values in the range T341:T352 for those rows where
the value in colum I is International and the value in column H is Shipper
SUMPRODUCT((I341:I352=" International ")*(H341:H352=" Shipper "),(T341:T352))
Thanks
|