alternate column to be taken for formula dragging

[andrei461]

Hello forum friends,

i have a formula in B1

SUMIF($E$2:$E$50,"XXX",H$2:H$50)

i want to drag this formula in row B1:EZ1

Quest: i want the sum to be taking of every alternate column for example

Cell C1 Formula: SUMIF($E$2:$E$50,"XXX",J$2:J$50)
Cell D1 Formula: SUMIF($E$2:$E$50,"XXX",L$2:L$50)
..and so on
it can be done through VBA, however i want to know is there any way it can be done through formula.

Excel is attached for your refernce.

Thanks in advance

[Limor_OP]

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

[José Augusto]

Try this formula in C1 and drag forward

Please Login or Register  to view this content.

[andrei461]

Thanks Augusto.

Thats an awesome way of referencing column via index.

Thanks for ur fast response.

[José Augusto]

You are welcome.

I'm happy to have helped.