Select Records for Subtotals Based on a Given Condition

[Ben Moore]

I have a LONG list of jobs that are sort alphabetically by customer name
in one worksheet. I would like to create another worksheet that can
go through the first worksheet ('KEN_S_QUERY') and select the rows where
in a certain column there is a certain customer, and total up the dollar
amount in the column next to the customer name. I am very familiar with
access, which makes it harder to word my question here. I would use
access, but I need the graphing a charting functions of excel in this
case. Is there a way (perhaps through SQL? please dear god, SQL.) to
select certain amounts based on a value in the same row? I am familiar
with VBA and SQL, so don't be afraid to use them if you can help me. Any
help is greatly appreciated.

cheers,
Ben Moore

 

[Ben Moore]

Perhaps a better way would be for me to subtotal each customer and then
create references to the subtotals? I would have two or three levels of
grouping for the subtotals, so how do I specify that I only want values
from the subtotal group? Hope this adds a bit of clarification.

Again, any help is greatly appreciated.

cheers,
Ben Moore

 

[Andy B]

Hi

Have a look at the SUMIF function. This should help you.

 

[Ben Moore]

The PivotTable/PivotChart method turned out to do exactly what I wanted.
Much appreciated. Always saw those Pivot options, never knew what they did.

Thanks again.

cheers,
Ben Moore

 

[onedaywhen]

Ben Moore wrote ...

I am very familiar with
access, which makes it harder to word my question here. I would use
access, but I need the graphing a charting functions of excel in this
case. Is there a way (perhaps through SQL? please dear god, SQL.

There's someone who's always banging on about such matters in these
ngs:

http://groups.google.com/[email protected]

http://groups.google.com/[email protected]

But I'm sure he/she would also like you to note:

http://groups.google.com/[email protected]

--

 

[Ben Moore]

must have missed the fact that im not very familiar with excel... or
missed all the replies to which i responded, "thank you" because they
did help me... so thank you for trolling, and not really offering advice
beyond "please read some other group, where your help may not be found
because i have already trolled them"... sod off...