#1   Report Post  
Old November 16th 19, 11:02 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2018
Posts: 21
Default A sum problem

I have the follwing sheet

A B C D E F G H I J K
101* 400* 18* 200* 2* 200* 8* 200* 6* 200* 10
102* 400* 12* 200* 5* 200* 7* 200* 4* 199* 8
103* 399* 17* 199* 7* 200* 7* 199* 9* 199* 10
104* 395* 13* 195* 5* 200* 6* 195* 7* 190* 5
105* 390* 15* 195* 7* 195* 2* 195* 8* 190* 3
106* 390* 12* 195* 5* 190* 2* 195* 7* 190* 5

I like to calculate the numbers in column C using a formula in stead of doing it manually.

The reuslts are calculated from this logic:

Columns C is the sum of the two highest values in columns E, G, I and K, but only if the numbers are next to one of the two highest numbers in columns D, F, H and J.

Thus the resultat for 101 is 18 because the two highest numbers in D, F, H and J are 200 and the two highest numbers in E, G, I and K are 8 and 10.

The resultat of 103 is 17 because 7 is to the right of 200 (highest number in D, F, H and J) a,d 10 is the highest number to the right of an occurance of 199.

I hope you understand the logic.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel startup problem. Possible problem with stdole32.tlb Walter Briscoe Excel Programming 2 September 26th 11 07:09 PM
Colon at the end of excel file name(ex: problem.xls:1, problem.xls financeguy New Users to Excel 2 January 15th 10 02:15 AM
Started out as an Access problem. Now an Excel problem RobertM Excel Discussion (Misc queries) 2 April 26th 06 07:30 PM
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? OCI Excel Programming 0 May 16th 04 10:40 PM


All times are GMT +1. The time now is 02:31 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017