Vlookup?

[Doug]

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$502>0,$S3:$AY502,33,FALSE))

 

[Tom Hutchins]

Try
=SUMIF(S3:S502,">0",AY3:AY502)

Hope this helps,

Hutch

 

[Niek Otten]

=SUMIF($S$3:$S$502,">0",$AY$3:$AY$502)