Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How do I do this for every row?
Example: =SUM(C4*0.5) =SUM(E4*15) =SUM(G4+F4+D4) =SUM(I4-H4) |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The first question is what are you intending the SUM function to do in each
of your formulae? In what way do you want =SUM(C4*0.5) to differ from =C4*0.5 ? In what way do you want =SUM(E4*15) to differ from =E4*15 ? In what way do you want =SUM(G4+F4+D4) to differ from =G4+F4+D4 ? In what way do you want =SUM(I4-H4) to differ from =I4-H4 ? If you don't understand what the SUM function does, try looking it up in Excel help. If you want to fill the formulae down a column, look at the topic "fill" in Excel help. -- David Biddulph Bigdaddykdk wrote: How do I do this for every row? Example: =SUM(C4*0.5) =SUM(E4*15) =SUM(G4+F4+D4) =SUM(I4-H4) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
randomly does/doesn't print full page | Excel Discussion (Misc queries) | |||
File view - full page | Excel Discussion (Misc queries) | |||
Rows not printing on full page | Excel Discussion (Misc queries) | |||
COPING FULL PAGE PATTENS TO ANOTHER PAGE | Excel Worksheet Functions | |||
I want 20 rows in excel to take up full A4 page | Excel Worksheet Functions |