Multiple Counting

[elad]

Hi

Can anyone help me make a formula solving this problem:
Have 2 columns pr date (person and points) that I want to add up in a tabel.

Have tried som SUMPRODUCT formula, but cant get it to work.

Se attached sheet for more info.

[Richard Buttrey]

Hi,

I suggest you change your layout as in the attached.

HTH

[elad]

Hi thanks!

That will work very good, but I would prefer, because of easiness of registration (several persons) /layout to have it like the format in the sample. Any other suggestions?

[DonkeyOte]

Using your sample file:

Please Login or Register  to view this content.

edit: remember to modify delimiters (function names) per your locale - this is not specified in your profile (which would be helpful) but Ark1 implies Sweden ?

[elad]

Nice - worked very well!

Elad Norway

[DonkeyOte]

Elad Norway

Apologies - it would be helpful if you put this in your profile as locale is often (highly) relevant...

[elad]

Thanks - I will do that