Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel startup problem. Possible problem with stdole32.tlb | Excel Programming | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming |