I need help with a conditional formula

[trib]

I need to find a formula for the following:

If there is a value higher than 10 in the range (A..:A..), multiply
each of the values by 2 and show their resulting sum.

I appreciate your time and help


+-------------------------------------------------------------------+
|Filename: sample_file.doc |
|Download: http://www.excelforum.com/attachment.php?postid=5202 |
+-------------------------------------------------------------------+

 

[Gary''s Student]

=IF(MAX(A:A)>10,2*SUM(A:A),"")

 

[trib]

Thank you for your swift response.

However, I need to have multiplied by 2 only those values in the range
which are higher than 10.

Using your formula I get 90. In my example (see sample file) I should
get 44

 

[RagDyer]

Try this:

=SUMPRODUCT((C1:C100>10)*(C1:C100)*2)