Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup a value in column B but return value in Column A | Excel Discussion (Misc queries) | |||
Vlookup to change a column | Excel Worksheet Functions | |||
VLookup & Column Sum | Excel Worksheet Functions | |||
Vlookup a column then a row | Excel Worksheet Functions | |||
Vlookup through entire column | Excel Worksheet Functions |