Sumproduct large for every over cell in a specific row.

[lambi153]

Hi,

I had a formula which worked out the sumproduct large for a range of cells which excluded the highest figure.

=SUMPRODUCT(LARGE('Stableford scores Summer 2018'!B5:AG5,{2,3,4,5,6}))

The problem I have is that I don't want to include the value in every other column i.e C5,E5,G5 etc. Does anyone know how I might be able to edit the code to do this?

I tried the following but it returns VALUE!

[COLOR=#333333]=SUMPRODUCT(--(MOD(COLUMN(B5:AG5),2)=1),--(B5:AG5),[/COLOR]{2,3,4,5,6}[COLOR=#333333])[/COLOR]

Thank you in advance.

 

[DRSteele]

Those formulas must be combined. SUMPRODUCT would need to be entered with Ctrl+Shift+Enter because it's a complex array formula. I changed it to SUM (entered with

Ctrl+Shift+Enter) so there'll be no confusion.

Remember, Ctrl+Shift+Enter first, then copy down after: ​

=SUM(LARGE((MOD(COLUMN(B5:AG5),2)=1)*B5:AG5,{2,3,4,5,6}))

​