| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUMIFS in Programming
Many thanks to all for the responses which I will get time to try out
tonight. I much appreciate your help and the exremely fast replies. I am very grateful Graham On 07/04/2010 10:43, Graham wrote: Below is waht ideally I would like to do with a procedure and I know this will not work with n in a formula, it was just to show the concept of what I was after. I would appreciate any guidance. Graham For n = 37 To 44 Cells(3, n).Select ActiveCell.FormulaR1C1 = _ "=SUMIFS(R15C14:R600C14,R15C13:R600C13,R2Cn,R15C4: R600C4,R3C35)" Next n |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use sumifs - | Excel Worksheet Functions | |||
| Sumifs | Excel Discussion (Misc queries) | |||
| Sumifs (I think) | Excel Worksheet Functions | |||
| Sumifs & Not Like | Excel Discussion (Misc queries) | |||
| SUMIFS | Excel Discussion (Misc queries) | |||
![Graham[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
