Thread: SUMIF Function
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default 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.