sum column and calculate numbers 0 in the same column with 1,5
Hi Gutti,
Try
=SUMIF(B2:B33,"0")*1.5+SUMIF(B2:B33,"<0")
Looks like you are using a European setup so you
will have to alter the separators to suit.
HTH
Martin
"Gutti" wrote in message
...
I have numbers 0 and <0 in a column B2 to B33. I have to multiply the
numbers 0 with 1,5 and add the column. Please help.
Gutti
|