YB Girl,

Please provide more detail. Give actual examples with expected results.

For example:
If (1+2) 0 then ((1+2) * 3) + ((4+5)*6) else 0 (or nothing or error
message or (1+2) or ((1+2)*3)

=IF(sum(A1:A2)0,(sum(A1:A2)*A3)+(sum(A4:A5)*A6)," the sum is not greater
than zero!!!")

Also you say "If a sum of numbers is greater than 0", what results do you
want if it is less than/equal to 0?

HTH,

Conan






"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.