Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup and Sum
Hello, could someone please help me with the following?
I need Excel 2003 to Vlookup column G and look up the number: 100206. Then, I need it to sum all the values in column O and place the final summed figure in cell: AA3. I am using Windows XP and Excel 2003. The title heading for column G (cell: G2) is: Cost Centre Code (Baseline). The title heading for column O (cell: O2) is: Actual Expenditure (inc.GST). The name of the worksheet is: Register. Any help with this would be greatly appreciated. Kind regards, Chris. *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup and Sum
If AA3 is on the same "Register" worksheet, you can use:
=sumif(g:g,100206,o:o) if the value is a real number or =sumif(g:g,"100206",o:o) if the value is text (not a number) If AA3 cell is on a different sheet: =sumif(Register!g:g,100206,Register!o:o) or =sumif(Register!g:g,"100206",Register!o:o) Each of these will sum the values in column O only if the value in column G is 100206/"100206". Chris Hankin wrote: Hello, could someone please help me with the following? I need Excel 2003 to Vlookup column G and look up the number: 100206. Then, I need it to sum all the values in column O and place the final summed figure in cell: AA3. I am using Windows XP and Excel 2003. The title heading for column G (cell: G2) is: Cost Centre Code (Baseline). The title heading for column O (cell: O2) is: Actual Expenditure (inc.GST). The name of the worksheet is: Register. Any help with this would be greatly appreciated. Kind regards, Chris. *** Sent via Developersdex http://www.developersdex.com *** -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup and Sum
Thanks Dave - really appreciate your excellent help,
Cheers, Chris. *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
Vlookup problem - unable to get the vlookup property | Excel Programming | |||
using a vlookup to enter text into rows beneath the vlookup cell | Excel Programming | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel |