If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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)) |
#2
|
|||
|
|||
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)) |
#3
|
|||
|
|||
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)) |
Thread Tools | |
Display Modes | |
|
|