Conditional sum of columns

If I have 1 row with 5 columns of data, how do I conditionally sum the
columns based on whether the column is greater than a value in another
separate cell? For example,

A B C D E
5 32 16 22 6 89
6
7 3


I only want to sum A5:E5 if the column is greater than the contents of A7.
In this example, the answer would be (6+89)=95. If A7=1, then the answer
would be (16+22+6+89)=133.

=sumif(A1:E1,">"&A7)

"randys" wrote:

> If I have 1 row with 5 columns of data, how do I conditionally sum the
> columns based on whether the column is greater than a value in another
> separate cell? For example,
>
> A B C D E
> 5 32 16 22 6 89
> 6
> 7 3
>
>
> I only want to sum A5:E5 if the column is greater than the contents of A7.
> In this example, the answer would be (6+89)=95. If A7=1, then the answer
> would be (16+22+6+89)=133.
>

Try...

=IF(A7<>"",SUM(INDEX(A5:E5,A7+1):E5),"")

Note that the formula sums all columns when A7 equals 0.

Hope this helps!

In article <0C011209-DDE9-4D73-A36F-6CADAB809502@microsoft.com>,
randys <randys@discussions.microsoft.com> wrote:

> If I have 1 row with 5 columns of data, how do I conditionally sum the
> columns based on whether the column is greater than a value in another
> separate cell? For example,
>
> A B C D E
> 5 32 16 22 6 89
> 6
> 7 3
>
>
> I only want to sum A5:E5 if the column is greater than the contents of A7.
> In this example, the answer would be (6+89)=95. If A7=1, then the answer
> would be (16+22+6+89)=133.