VLOOKUP and sums?

[mattygriff]

I have a table as follows.

A       B               C
13	Mar-2008	£2,095,154.10
14	Apr-2008	£1,808,448.11
15	May-2008	£1,027,256.12
16	May-2008	£965,029.63
17	Jun-2008	£3,112,928.28
18	Jul-2008	£1,937,584.56

I need to get the value from column C into a separate sheet based on the value of column B. To date I have been using VLOOKUP but that doesn't work when you have multiple entries for the same month as in 15 and 16 above.

Is there a way to retrieve the sum of any such multiple entries using VLOOKUP or am I going to have to code something?

Thanks in advance.

 

[SkipVought]

Hi,

Try using the SUMIF function.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[mattygriff]

Thanks Skip - easier than I could have possibly hoped!