View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
 
Posts: 860
Default 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