Re: multi-column data consolidation

From: Bernard Liengme (bliengme_at_stfx.TRUENORTH.ca)
Date: 08/28/04 

Date: Sat, 28 Aug 2004 14:50:22 -0300

Question is not clear to me.
Not sure what 'add up or compile' means with text entries
Perhaps, in G2 enter =A2&B2&C2 and copy down to row 1000
If numbers, to sum EVERYTHING use =SUM(A:A, B:B, C:C) 

-- 
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address
"pronto >" <<pronto.1bplb2@excelforum-nospam.com> wrote in message
news:pronto.1bplb2@excelforum-nospam.com...
> Hi guys, here is my problem....
>
> Scenario:
>
> - Column A to F are months (Jan to June)
> - Beneath each month (starting row 2 downwards), text data will be
> entered.
>
> Question:
>
> How can I have the six months add up or compiled as a single column
> database in another *** or a separate column in that same ***? I
> will be adding data every so often under these months and it should
> update the database.
>
> Thank you for any assistance/help.
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>