vlookup

N

Nigel

Hi,
i am not experienced with vlookup but im sure it is what i need. i have
column A with a vertical list including utilities, health etc, and column E
has the figures i need to add up according to the column A list. how can i
achieve this as it is quite donfusing.

thanks,


Nigel
 
D

Debra Dalgleish

If you're trying to summarize the data, based on the entries in column
A, you could use a pivot table. There are instructions for pivot tables
in Excel's Help, and Jon Peltier has information and links:

http://peltiertech.com/Excel/Pivots/pivotstart.htm

In your pivot table, put the field for column A in the row area, and
column E in the data area.
 
J

Jay

i am not experienced with vlookup but im sure it is what i need. i
have column A with a vertical list including utilities, health etc,
and column E has the figures i need to add up according to the column
A list.
Click to expand...

It's not exactly what you asked for, but (if I understand the problem
correctly) maybe the example in the CSV file below will be helpful.

-------------------- cut here --------------------
utilities,,,,21
health,,,,23
gas,,,,21
recreation,,,,76
gas,,,,243
health,,,,65
recreation,,,,23
recreation,,,,54
health,,,,32
gas,,,,78
TOTAL,,,,=SUM(E1:E10)

gas,,,,"=SUMIF($A$1:$A$10,A13,$E$1:$E$10)"
health,,,,"=SUMIF($A$1:$A$10,A14,$E$1:$E$10)"
recreation,,,,"=SUMIF($A$1:$A$10,A15,$E$1:$E$10)"
utilities,,,,"=SUMIF($A$1:$A$10,A16,$E$1:$E$10)"
TOTAL,,,,=SUM(E13:E16)
,,,,"=IF(E11=E17,"""",""ERROR"")"
 
Top