Formula Problem

Y

YB Girl

I want to add a group of numbers. If that sum is greater than 0, I want the
sum to be multiplied by a number.

I need help if anyone can tell me how.

Thanks.
 
K

Kevin B

How about something along the lines of:

=IF(SUM(A1:A40)>0,SUM(A1:A40)*10,SUM(A1:A40))

Substituting the A1:A40 range and the number 10 to those relevant to your
formula.
 
R

RagDyer

Say the number to multiply is entered in B1, and you want to total the
numbers in A1 to A10:

=IF(SUM(A1:A10)>0,B1*SUM(A1:A10),0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Error 6
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
Excel Formula or equation 3
sum last 3 numbers greater that 0 in a range 0
Excel How to add numbers in same cell? 2
Sumproduct question 4
if formula 4
Sumif number is greater than a number but less than another number 2

Top