Prev: Macro Help
Next: Excel Security
From: Doug on 4 May 2010 11:33
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))

From: Tom Hutchins on 4 May 2010 11:40
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$502>0,$S3:$AY502,33,FALSE))
>
From: Niek Otten on 4 May 2010 11:46
=SUMIF($S$3:$S$502,">0",$AY$3:$AY$502)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Doug" <Doug(a)discussions.microsoft.com> wrote in message
news:293C248A-0785-47AA-8CEE-E137369519F9(a)microsoft.com...
>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))
>

 | 
Pages: 1
Prev: Macro Help
Next: Excel Security