1

When using fill down on a column is it possible to increment row references rather than column references:

| --------------------- |  
| =dogs!B15+cats!B27    |  
| --------------------- |  
| =dogs!C15+cats!C27    |  
| --------------------- |  
| =dogs!D15+cats!D27    |  
| --------------------- |  

rather than:

| --------------------- |  
| =dogs!B15+cats!B27    |  
| --------------------- |  
| =dogs!B16+cats!B28    |  
| --------------------- |  
| =dogs!B17+cats!B29    |  
| --------------------- |  
1
1

Instead of filling down, use an array formula with transpose(), like this:

=arrayformula(transpose(dogs!B15:D15 + cats!B27:D27)))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.