Sumproduct large for every other cell in a specific range.

Thank you for the formula Tim. The workbook is something which records a group of golfers weekly scores, sometimes if the weather has closed the course then we can't play. On these occasions there will be nothing in both the score column (which forms part of the sumproduct large and also the column next to it.

I used your formula and it doesn't come up with any errors which is nice but is not working anything out for the nest 5 scores (cell is blank).

B6 C6 D6 E6 F6 G6 H6 I6 J6 K6 L6 M6 N6 O6 P6 Q6 R6 S6 T6 U6 V6 W6 X6 Y6 Z6 AA6 AB6 AC6 AD6 AE6 AF6 AG6
39 2 35 1 23 7 31 3 29 6 32 2 23 6 33 2 33 4 27 4 26 6 23 5 33 3

The smaller figures are what position that person ended up on the given day which is why I need it to not count that column but it also needs to ignore anytime when we haven't played.

snipe.JPG

Please note: this is NOT code - code is something else. This is a formula.

Jolly good!

Joking apart, if you ask for code, and get code, when in fact you want a formula, you'll be up the creek without a paddle. Just sayin' ...

Hi Lambi,

It is always better to attach a workbook for your problem. I can't tell if the players names are the rows or if the rows are the dates you played. Your picture doesn't display enough for me to tell. If you give us an attached example, I'm sure we can do a formula.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.