Remember Me?

#1
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
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.

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Walter Briscoe Excel Programming 2 September 26th 11 07:09 PM financeguy New Users to Excel 2 January 15th 10 02:15 AM RobertM Excel Discussion (Misc queries) 2 April 26th 06 07:30 PM OCI Excel Programming 0 May 16th 04 10:40 PM

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