Vlookup?
=SUMIF($S$3:$S$502,"0",$AY$3:$AY$502)
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Doug" wrote in message
...
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))
|