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.
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.
Try this: using range A1:L1 for your 12 values
=SUM(A1:L1)-SUM(SMALL(A1:L1,{1,2,3}))
sorry, cant get it to work.
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
my bad. i went back and had left out a comma. thanks cutter
You're welcome. Glad you got it to work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks