software

I am trying to find a function or any other means to add up a row of numbers. The example is:

Week numbers on row 2
Value on row 3
Cell A1 has current week number

What function will look at cell A1 and return the total of the values in row 3 that have a week number of cell 1 or less.

Example :
Type 11 into current week cell at A1
Total returns the total of the value in row 3 that are against weeks 1 to 11.

I hope that's clear enough. I have tried SUMIF but cannot get the =lt; to work within the function.
=SUMIF(2:2,quot;lt;=quot;amp;A1,3:3)

--

Regards,

Peo Sjoblomquot;andyhoferquot; gt; wrote in message
...
gt;
gt; I am trying to find a function or any other means to add up a row of
gt; numbers. The example is:
gt;
gt; Week numbers on row 2
gt; Value on row 3
gt; Cell A1 has current week number
gt;
gt; What function will look at cell A1 and return the total of the values
gt; in row 3 that have a week number of cell 1 or less.
gt;
gt; Example :
gt; Type 11 into current week cell at A1
gt; Total returns the total of the value in row 3 that are against weeks 1
gt; to 11.
gt;
gt; I hope that's clear enough. I have tried SUMIF but cannot get the =lt; to
gt; work within the function.
gt;
gt;
gt; --
gt; andyhofer