ExcelBanter - Vlookup?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Vlookup? (https://www.excelbanter.com/excel-worksheet-functions/263038-vlookup.html)

Doug

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))

Tom Hutchins

Vlookup?

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

Hope this helps,

Hutch

"Doug" wrote:

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))

Niek Otten

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))

All times are GMT +1. The time now is 01:43 AM.