If the first sum of numbers is not greater than 0, then my answer is simply
the second sum of numbers multiplied by a number. In other words, if the
first sum of numbers is 0, I just want 0 added to the second part of the
equation.

"PCLIVE" wrote:

Your request seems pretty straight forward with the exception of some
confusing wording.

If the sum of a numbers (A1:A5) is 0, then multiply sum by a number (C1).
Then add that sum to another sum of numbers (B1:B5) multiplied by another
number (C2). Ok, so what if the first sum is not greater than zero? In my
formula below, I have it returning blank.

=IF(SUM(A1:A5)0,(SUM(A1:A5)*C1)+(SUM(B1:B5)*C2)," ")

HTH,
Paul

--

"YB Girl" wrote in message
...
I don't think I described it right. This is what I am trying to do:

One formula... If a sum of numbers is greater than 0, multiply that sum
by
a number and then add that number to another sum of numbers multiplied by
another number.