Prev: Edit Excel file
Next: VLOOKUP IS ERROR
From: Dave on 7 May 2010 17:14
Thanks Ron,

Works like a charm



"Ron Rosenfeld" wrote:

> On Thu, 6 May 2010 13:02:01 -0700, Dave <Dave(a)discussions.microsoft.com> wrote:
>
> >Hoping someone can help.
> >
> >I have a sheet that has 12 months of data going across 12 columns. Each
> >column has a heading for each month i.e 1, 2 ,3 ... There are multiple rows
> >of data. I need a formula that will sum the columns of data based on the
> >month that is entered in cell A1. For example, if I enter 5 in cell A1, I
> >want the YTD formula to add up only the first 5 months of data.
> >
> >Thanks in advance for any help.
>
>
> I assume you want to sum everything that is in one row:
>
> =SUM(OFFSET(B2,,,1,A1))
>
> Change B2 to the cell that has the data for January in the row of choice.
>
> --ron
> .
>
From: Ron Rosenfeld on 7 May 2010 20:53
On Fri, 7 May 2010 14:14:01 -0700, Dave <Dave(a)discussions.microsoft.com> wrote:

>Thanks Ron,
>
>Works like a charm
>

Glad to help. Thanks for the feedback.
--ron
From: Ashish Mathur on 8 May 2010 03:43
Hi,

Try this

=sumif($B2:$N2,$A$1,$B3:$N3)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Dave" <Dave(a)discussions.microsoft.com> wrote in message
news:4F460C6A-753C-4CEC-8677-89D9222A4592(a)microsoft.com...
> Hoping someone can help.
>
> I have a sheet that has 12 months of data going across 12 columns. Each
> column has a heading for each month i.e 1, 2 ,3 ... There are multiple
> rows
> of data. I need a formula that will sum the columns of data based on the
> month that is entered in cell A1. For example, if I enter 5 in cell A1, I
> want the YTD formula to add up only the first 5 months of data.
>
> Thanks in advance for any help.
>
First  |  Prev  | 
Pages: 1 2
Prev: Edit Excel file
Next: VLOOKUP IS ERROR