Sum column of vlookup
 

Hi all,

Here I am again trying to do things that I don't know how to do.

Here's the formula in O37 - =VLOOKUP(O18,DE18:DG36,3)

Of course this is for row 18 in column O and there are 36 rows.

O37 should sum all the rows, not just row 18.

It's probably some form of =sum and an array, ahh.

Thanks,

Michele

Sum column of vlookup
 

One guess ..

Try in O37: =SUMIF(DE18:DE36,O18,DG18:DG36)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mjones" wrote in message
ups.com...
Hi all,

Here I am again trying to do things that I don't know how to do.

Here's the formula in O37 - =VLOOKUP(O18,DE18:DG36,3)

Of course this is for row 18 in column O and there are 36 rows.

O37 should sum all the rows, not just row 18.

It's probably some form of =sum and an array, ahh.

Thanks,

Michele

Sum column of vlookup
 

On Oct 15, 7:08 pm, "Max" wrote:
One guess ..

Try in O37: =SUMIF(DE18:DE36,O18,DG18:DG36)
--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik
---"mjones" wrote in message

ups.com...



Hi all,

Here I am again trying to do things that I don't know how to do.

Here's the formula in O37 - =VLOOKUP(O18,DE18:DG36,3)

Of course this is for row 18 in column O and there are 36 rows.

O37 should sum all the rows, not just row 18.

It's probably some form of =sum and an array, ahh.

Thanks,

Michele- Hide quoted text -

- Show quoted text -

Not quite; it's still only adds one row.

Please try this test spreadsheet to see what I mean -
http://www.quality-computing.com/test.xls.

Sum column of vlookup
 

Ah, I see. This should do it:
=SUMPRODUCT(--($DE$18:$DE$36=U$18:U$36),$DG$18:$DG$36)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mjones" wrote
Not quite; it's still only adds one row.

Please try this test spreadsheet to see what I mean -
http://www.quality-computing.com/test.xls.

Sum column of vlookup
 

On Oct 15, 7:43 pm, "Max" wrote:
Ah, I see. This should do it:
=SUMPRODUCT(--($DE$18:$DE$36=U$18:U$36),$DG$18:$DG$36)
--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik
---
"mjones" wrote



Not quite; it's still only adds one row.

Please try this test spreadsheet to see what I mean -
http://www.quality-computing.com/test.xls.- Hide quoted text -

- Show quoted text -

Perfect. Rocket science to me when you get into that double dash.
Thanks!!

Sum column of vlookup
 

welcome. glad it helped.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mjones" wrote
Perfect. Rocket science to me when you get into that double dash.
Thanks!!