SUMIF Function
Hi,
One way is with SUMPRODUCT.
With your stock symbol data in C2:C100
With your option symbol data in D2:D100
With your figures to add in E2:E100
Type the stock symbol you want as criteria into F2
Type the option symbol you want as criteria into G2
=SUMPRODUCT(--(C2:C100=F2)*(D2:D100=G2)*(E2:E100))
Regards - Dave.
|