Thread: Vlookup?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Doug Doug is offline
external usenet poster
 
Posts: 460
Default Vlookup?

I am trying to sum the cells in column "AY" for each row that has a positive
value in column "S"
I am very confused and this is what I have so far. Can you help me please?

=SUM(VLOOKUP($S$3:$S$5020,$S3:$AY502,33,FALSE))