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.:confused:


--
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

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

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

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

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

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