SQL in Excel data

[Vsn]

Hi all,

Is there a possibility/way to run an SQL query in an excel data sheet?

I have quite some data like the sample below, now i would like to have the
sum of spending for each person. Like it is possible in Access.

A1 B1
Field1 Field2
Chuck 12,89
Mike 23,09
Jean 9,34
Chuck 30,00
Mike 3,80
Chuck 22,00
Mike 7,23
Jean 10,55
Jean 10,75
Jean 31,45
Chuck 19,99

Result
Field1 SumOfField2
Chuck 84,88
Jean 62,09
Mike 34,12

Advice would be appriciated.

Cheers,
Ludovic

 

[John]

Hi
You could use a formula like this =SUMIF(A2:A600,"Chuck",B2:B600)
adjust range to your need.
HTH
John

 

[Vsn]

Good idea, this will work for now. Thanks!

Hi
You could use a formula like this =SUMIF(A2:A600,"Chuck",B2:B600)
adjust range to your need.
HTH
John

 

[John]

You're welcome,
Sorry I couldn't help with SQL.
Regards
John

 

[Max]

A pivot can give you both the listing of unique names & their corresponding
amounts in a matter of seconds. Create a pivot on your source table, place
Field1 into ROW, Field2 into DATA (set to Sum). That's it. Check out the
results in the pivot sheet.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---