| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum column and calculate numbers 0 in the same column with 1,5
And the difference would be?
Don't get me wrong I'm all for streamlining formulae, but when you are just talking about two ways around a square. Why bother? Regards Martin "Ron Coderre" wrote in message ... If Martin interpreted your post correctly, try this: =SUM(SUMIF(B2:B33,"0")*0.5,B2:B33) Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Ron Coderre" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Figures in a column if ajacent column has particular da | Charts and Charting in Excel | |||
| Calculate an Excel column that contains numbers and #Values | Excel Discussion (Misc queries) | |||
| calculate average in a column based on criteria in another column | Excel Discussion (Misc queries) | |||
| how do you calculate a column of numbers - eg. A1 to A20? | Excel Discussion (Misc queries) | |||
| calculate which cells in column A will give me the total of column | Excel Worksheet Functions | |||
Threaded Mode
