[Solved] Reports on multiple columns

[helpcnm]

i am trying to create a formula that will match across multiple columns. currently, i add each column then do a 'sum' on those columns. there has to be an easier way. here is the data

Code: Select all

product a	01/10/08	linea	linec	lineb	lined	linee
product b	01/04/08	lined	linee			
product a   01/09/08   lineb   lined   linee   linea   linb
etc

i am trying to find out how many 'linea' sold in col c thru col g for jan
right now i do 5 differant sums and then do a total report

when i try to just do a report, i get '0'. but if i do indivual tallys and then a totals report, i get '2'

please help if you can!

thank you!

Edit: Hagar: added the code BBCode tags to recreate the table layout and changed the title (was "calc Help!").

[Hagar Delest]

Can you upload here a small sample file? I think we need to see what you're doing for the 'report'.

NB: Please read the Survival Guide for the forum. Your title is not very explicit.

[helpcnm]

here's the file

[Villeroy]

Code: Select all

product a 01/10/08 linea linec lineb lined linee
product b 01/04/08 lined linee
product a 01/09/08 lineb lined linee linea linb

With your current table layout it is close to impossible. There are several options to extract all kinds of information with a layout like this:

Code: Select all

product a 01/10/08 linea
product a 01/10/08 linec
product a 01/10/08 lineb
product a 01/10/08 lined
product a 01/10/08 linee
product b 01/04/08 lined
product b 01/04/08 linee
product a 01/09/08 lineb
product a 01/09/08 lined
product a 01/09/08 linee
product a 01/09/08 linea
product a 01/09/08 lineb

Notice that the information in this table is exactly the same as in your initial example.

Edit: Attached my own example

[Hagar Delest]

If you can't avoid the original table layout, why not using the DataPilot feature? See attachment.

[helpcnm]

ok thanks, will do that. appreciate it!