| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting ?
i have a row of 12 cells. each numeric value in the cells is totaled in the 13th cell. I want to create a formula that will look at each cell and not add the cells with the 3 lowest numerical values to the total in the 13 cell in that row.  -- Ranger.1 ------------------------------------------------------------------------ Ranger.1's Profile: http://www.excelforum.com/member.php...o&userid=30849 View this thread: http://www.excelforum.com/showthread...hreadid=505174 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting ?
Try this: using range A1:L1 for your 12 values =SUM(A1:L1)-SUM(SMALL(A1:L1,{1,2,3})) -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=505174 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting ?
sorry, cant get it to work. -- Ranger.1 ------------------------------------------------------------------------ Ranger.1's Profile: http://www.excelforum.com/member.php...o&userid=30849 View this thread: http://www.excelforum.com/showthread...hreadid=505174 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting ?
Does that mean you're getting the wrong answer or the formula is producing an error? What values and cells are you using? What result did you get? It's always best to provide as much detail as possible -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=505174 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting ?
my bad. i went back and had left out a comma. thanks cutter -- Ranger.1 ------------------------------------------------------------------------ Ranger.1's Profile: http://www.excelforum.com/member.php...o&userid=30849 View this thread: http://www.excelforum.com/showthread...hreadid=505174 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting ?
You're welcome. Glad you got it to work. -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=505174 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
| Conditional Formatting Error | Excel Worksheet Functions | |||
| difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
| conditional formatting question | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
