![]() |
|
#7
|
|||
|
|||
|
Hi Todd,
The last SUMIF is missing a lot of info. Here is a correction that works for me: Range("t9").Select ActiveCell.FormulaR1C1 = "=SUMIF(R[1]C[-13]:R[36]C[-13],"">0"",R[1]C[-14]:R[36]C[-14])+SUMIF(R[1]C[-13]:R[36]C[-13],"">0"",R[1]C[-6]:R[36]C[-6])+SUMIF(R[1]C[-13]:R[36]C[-13],"">0"",R[1]C[-5]:R[36]C[-5])" Another (shorter) solution is: Range("t9").Select ActiveCell.FormulaR1C1 = "=SUMPRODUCT((R[1]C[-13]:R[36]C[-13]>0)*(R[1]C[-14]:R[36]C[-14]+R[1]C[-6]:R[36]C[-6]+R[1]C[-5]:R[36]C[-5]))" ... which corresponds to the more readable: =SUMPRODUCT((G10:G45>0)*(F10:F45+N10:N45+O10:O45)) Is there a special reason to why you use the R1C1-style? This code I find it easier to read: Range("t9").Select ActiveCell.Formula = "=SUMPRODUCT((G10:G45>0)*(F10:F45+N10:N45+O10:O45) )" I hope it works now for you! Kind regards Bjorn |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Character style stripped while applying paragraph style | sams_gates | Word | 0 | 08-29-2009 02:03 AM |
| AutoFormat with style | zac | Word | 0 | 01-12-2009 01:12 PM |
| Need to delete style and style text | mclan | Word | 0 | 08-04-2008 12:05 PM |
| Style shortcut | billzant | Word | 0 | 01-06-2007 02:13 AM |
Multiple criteria in SUMIF?
|
pumpkin head | Excel | 1 | 02-17-2006 09:06 AM |