Formula to calculate average of every other cell

[froffel]

Hello,

I have a row of data starting in cell E4 that could, theoretically, go to the far right end of the spreadsheet. I need to enter a formula in cell D4 that calculates the average of every other cell in this row, starting with E4, that is E4,G4,I4,K4... is this possible?

Thanks in advance for your assistance

[DonkeyOte]

You can use an Array, eg:

Please Login or Register  to view this content.

[NBVC]

tRY

=AVERAGE(IF((MOD(COLUMN(E4:IV4)-COLUMN(E4),2)=0)*(E4:IV4),E4:IV4))

Confirmed with CTRL+SHIFT+ENTER not just ENTER

[froffel]

my mistake... was just pressing enter... works like a charm.
THANKS!!!

[froffel]

in some cases the row contains only zero's giving the formula the result that displays #DIV/0! but i would prefer if it would display just a 0 in this case... is that possible?

thanks again in advance

[DonkeyOte]

Given the nature of the calculation I would opt for

Please Login or Register  to view this content.

[froffel]

thanks... you guys have been a HUGE help... will definitely be clicking that scale, never knew that until i saw your signature... THANKS AGAIN!!!

[froffel]

So I am using this formula (as per previous post in thread)...

=LOOKUP(9.99999999999999E+307,CHOOSE({1,2},0,AVERAGE(IF(ISNUMBER(E4:IV4)*(MOD(COLUMN(E4:IV4),2)=1),E4:IV4))))
confirmed with CTRL + SHIFT + ENTER

But I need to change it up so that the formula is entered into cell E4 and calculates the average of every third cell to the end of the row (i.e. F4, I4, L4...) rather than every second cell and starting in D4 as is above.

Tried to tinker with the given formula with no luck

Thanks!

[DonkeyOte]

If we assume by every third column you mean from A rather than from E then perhaps:

Please Login or Register  to view this content.

[froffel]

yet another swift and perfect response... worked like a charm!!

thx for all your help