Excel problem
Solved/Closed
ptkdave
Posts
6
Registration date
Wednesday February 8, 2012
Status
Member
Last seen
February 9, 2012
-
Feb 9, 2012 at 04:52 AM
ptkdave Posts 6 Registration date Wednesday February 8, 2012 Status Member Last seen February 9, 2012 - Feb 9, 2012 at 05:58 PM
ptkdave Posts 6 Registration date Wednesday February 8, 2012 Status Member Last seen February 9, 2012 - Feb 9, 2012 at 05:58 PM
Related:
- Excel problem
- Excel date format dd.mm.yyyy - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Number to words in excel - Guide
- Screenshot in excel - Guide
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
2 replies
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
544
Feb 9, 2012 at 10:19 AM
Feb 9, 2012 at 10:19 AM
Hi David,
Assuming that each member has it's own row, try this formula:
Best regards,
Trowa
Assuming that each member has it's own row, try this formula:
=SUM(LARGE(D2:AN2;1)+LARGE(D2:AN2;2)+LARGE(D2:AN2;3)+LARGE(D2:AN2;4)+LARGE(D2:AN2;5)+LARGE(D2:AN2;6))
Best regards,
Trowa
ptkdave
Posts
6
Registration date
Wednesday February 8, 2012
Status
Member
Last seen
February 9, 2012
Feb 9, 2012 at 05:58 PM
Feb 9, 2012 at 05:58 PM
Thanks for help.
Dave
Dave