dilemma on writing a VBA code v/s querying

[buffalo]

Hi,

Suppose I have the following Columns in a simple Excel workbook:

Date Price Symbol Account etc...

and say I want to find the total Prices at Date = 3/2/2004

I can write a VBA but would it be more sensible to use any databse functionality?... (I have realized that if this were an SQL table, then i could have used SELECT sum(Price) from Table where Date = '3/2/2004'; etc... type of type which would have been much faster, is there such a functionality in Excel?)

Thank you in advance for any suggestions

 

[dk]

Hi,

You can just use one of Excel's built in formulas - SUMIF e.g.

Book1
	A	B	C	D
1	Date	Price
2	2/01/2004	3.76
3	2/01/2004	3.82
4	2/01/2004	4.10
5	2/01/2004	0.56
6	3/01/2004	3.11
7	3/01/2004	1.67
8
9
10	QueryDate	2/01/2004
11	Sumofpricesforthisdate	12.24
Sheet1

 

[buffalo]

Thanks Dan.

Is there a way, I can output my answers to a 'report'?

Basically, at the end of everyday, I have many calcultions to make and then input these values to a nice-looking report.

thanks