Is it possible to enter a formula for every second column?

[VBAhelp3456]

=SUMIFS(Sheet1!D$11:D$1460,Sheet1!$A$11:$A$1460,$B17,Sheet1!$B$11:$B$1460,$C$16)

=C4-C17

Here are my two formulas. Basically the first formula is entered into every second column whilst the second formula is entered into the alternating columns. Is there a way I can write the function that will alternate for me so all I have to do is drag the formula along? I have to enter this formula for about 20 columns so it is quite time consuming!

Thank you very much for you help!

[Glenn Kennedy]

Here's one way to do it. I haven't used your exact formulas, as they would be difficult to test, without a lot of typing. But it will give you an idea of where to go..