Search : in
By :

Sum the excess value in a row of cell

Last answer on Sep 13, 2008 3:25:46 pm BST prasanna, on Sep 9, 2008 1:37:35 pm BST 
 Report this message to moderators

Hello,
i need to add sum of values as shown in the below example

Ex:

Given Values

8
8.5
9
9.5
8.5
9

From the above set of numbers i need to sum the value which is greater than 8. the answer should be 4.5
(0+0.5+1+1.5+0.5+1 = 4.5)

Please help me what simple function can be used in excel'07 to make the above calculation

Regards

Configuration: Windows Vista
Google Chrome

Best answers for « sum the excess value in a row of cell » in :
PRINT BY CELL VALUE Show
Excel - Send value of cell to target Show Excel - Send value of cell to target Issue Solution Note Issue Is it possible to send the value of a cell (copy and paste special) to another cell where the value would not be disturbed when the source value changes to '0'? My...
Excel formula to get the cell with the text Show
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
[VBA] Detecting changes in cell Show[VBA] Detecting changes in cell The Event Change feature of a sheet will detects the change in the active cell but it gives no information about the content. The example given below will help you to find out if the cell was changed,...
Excel – Comparing cell A1 to entire A column in Sheet 2 ShowExcel – Comparing cell A1 to entire A column in Sheet 2 Issue Solution Note Issue I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to a new sheet....
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Ask your question Reply

1

Joe Cruix, on Sep 11, 2008 7:02:06 pm BST

=sum(A1..A6)

   
Reply to Joe Cruix

2

Ivan-hoe, on Sep 12, 2008 10:50:19 am BST

Hello prasanna,
Let's say your values are in cells A1 to A6

The easiest way to do it is to write an intermediate formula.
Write in cells B1 =IF(A1>8;A1-8;0) and extend this formula to B6
Then write in any cell =SUM(B1:B6)

If you wish only one formula
=SUMIF(A1:A6;">8")-(COUNTIF(A1:A6;">8")*8)

Ivan

   
Reply to Ivan-hoe

3

 Prasanna, on Sep 13, 2008 3:25:46 pm BST

Hi ivan

this solves my problem
thank you very much for the tips....

regards
prasanna

   
Reply to Prasanna
Ask your question Reply
They need your help