conditional formatting ?

  • Thread starter Thread starter Ranger.1
  • Start date Start date
R

Ranger.1

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:
 
Try this: using range A1:L1 for your 12 values

=SUM(A1:L1)-SUM(SMALL(A1:L1,{1,2,3}))
 
Does that mean you're getting the wrong answer or the formula i
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 possibl
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Excel VBA 1
Summing rows using formulas with variables 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Conditional formatting in Excel 2010 2
Excel Conditional Formatting 1
How to highlight the lowest valued cell in a column in Excel 2003 2
Excel How To Create A Min Formulas That Will Take The 4 Min Value In Ascending Order 4

Back
Top