Database-esq Question

Feb 28th, 2002, 07:34 PM

Hi all,
I have a 'table' that looks something like..
Name Code Sales Comment
... x yyy ......
... x yyy ......

Need to produce a report that looks something like...

Code: X Total Sales:$YYY
Code: Y Total Sales:$ZZZ

The data is kind of big, roughly 30 Megs
Can't use SUMIF etc. because the conditions are a lot more complicated than illustrated here.

Tried DCOUNTA, DSUM but found out the criteria gets too weird..
There are roughly 30 different codes.

What's the best way to do it? Trying to find ideas... Thanks guys

Help!!

NateO · Feb 28th, 2002, 08:05 PM

You're post is fairly vague but it smells like an array formula (or control-shift-enter (cse) formula).

Here's some examples of how they work:

http://www.j-walk.com/ss/excel/tips/tip74.htm

Remember you enter the formula like a normal one, but, instead of pressing enter, you press control-shift & enter at the same time.

HTH. Cheers,

Nate

Feb 28th, 2002, 08:16 PM

Thanks, exactly what I am looking for... Guess I can't phrase my questions properly.. Cheers

NateO · Feb 28th, 2002, 08:39 PM

Glad to hear the examples looked good. Your example was great if your wanted a general answer, all's well that ends well eh. Have a good one.

Cheers, Nate

[ This Message was edited by: NateO on 2002-02-28 19:39 ]

Chris Davison · Mar 1st, 2002, 01:33 PM

Quote:

On 2002-02-28 19:39, NateO wrote:
Glad to hear the examples looked good. Your example was great if your wanted a general answer, all's well that ends well eh. Have a good one.

Cheers, Nate

[ This Message was edited by: NateO on 2002-02-28 19:39 ]

Also, for a non-array approach, try searchign this board for "SUMIFs with multiple criteria" (SUMPRODUCT), which'll change your life via-a-vis extracting numerical info from a large database

HTH
Chris

ps Nate : Q) what goes "clip clop, clip clop, BANG !, clip clop" ?

(Friday evening joke...)

A) an Amish drive-by shooting

[ This Message was edited by: Chris Davison on 2002-03-01 12:41 ]

Feb 28th, 2002, 08:05 PM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	You're post is fairly vague but it smells like an array formula (or control-shift-enter (cse) formula). Here's some examples of how they work: http://www.j-walk.com/ss/excel/tips/tip74.htm Remember you enter the formula like a normal one, but, instead of pressing enter, you press control-shift & enter at the same time. HTH. Cheers, Nate __________________ Regards, Nate Oliver Microsoft Excel MVP Nate's Excel Blog

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 28th, 2002, 07:34 PM	#1
Guest Posts: n/a	Hi all, I have a 'table' that looks something like.. Name Code Sales Comment ... x yyy ...... ... x yyy ...... Need to produce a report that looks something like... Code: X Total Sales:$YYY Code: Y Total Sales:$ZZZ The data is kind of big, roughly 30 Megs Can't use SUMIF etc. because the conditions are a lot more complicated than illustrated here. Tried DCOUNTA, DSUM but found out the criteria gets too weird.. There are roughly 30 different codes. What's the best way to do it? Trying to find ideas... Thanks guys Help!!

Feb 28th, 2002, 08:16 PM	#3
Guest Posts: n/a	Thanks, exactly what I am looking for... Guess I can't phrase my questions properly.. Cheers

Feb 28th, 2002, 08:39 PM	#4
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Glad to hear the examples looked good. Your example was great if your wanted a general answer, all's well that ends well eh. Have a good one. Cheers, Nate [ This Message was edited by: NateO on 2002-02-28 19:39 ]