| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to sum rows
I have a database query that runs by a date range which can return different
amount of data based on date range this is the formula that i hand type into cells Can someone maybe help me with a formula to run a macro for this Thanks mike Range("G12").Select ActiveCell.FormulaR1C1 = "=SUM(RC[-2]-RC[-3])" Range("H12").Select ActiveCell.FormulaR1C1 = "=SUM(RC[-2]*RC[-1])" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy formula every x rows | Excel Worksheet Functions | |||
| Formula for Duplicating Rows!! | Excel Discussion (Misc queries) | |||
| I get error with "ROWS" in the formula - nested formula question | Excel Worksheet Functions | |||
| Insert rows, keep a formula? | Excel Worksheet Functions | |||
| can you hide rows with a formula? | Charts and Charting in Excel | |||
Threaded Mode
