Thread: sum column and calculate numbers 0 in the same column with 1,5
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
  
Posts: 2,118
Default sum column and calculate numbers 0 in the same column with 1,5
Try this:

=SUMIF(B2:B33,"0")*1,5

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"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


Reply With QuoteReply With Quote