Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

how to sum the even numbers only ????????

There are at least 2 approaches.

One is

Put in another column ( say your numbers are in A3 to A10) put in B3

=if(mod(A3,2)= 0,A3,0)

Copy this down to B10

Sum B3:B10

The other is to build a function which is given a range as a parameter and

steps through each cell in the range

Testing if it is even

Adding it if it is

Returning the total

Another way would be to use a conditional array...say you have values

in range a1:a12, you would enter the summation formula in a13 as follows:

=SUM(IF(MOD(A1:A12,2)=0,A1:A12))

to get the formula to work, you MUST hold down the <Ctrl><Shift> then

<Enter>. The result formula would have two brackets around the

formula like below...

{=SUM(IF(MOD(A1:A12,2)=0,A1:A12))}

the result should be 30

but i need to use one formula in one cell only to sum all even

numbers in specific column

Didn't find what you were looking for?
Find more on how to sum the even numbers only
Or get search suggestion and latest updates.

Related Topics:

- Summing on varying number of rows in Excel using VBA
- sum of series of natural numbers
- sum and difference of 2 bcd numbers
- sum and Multiply number and print in decimal
- C: Find the longest series of even and positive numbers
- Converting a "Stringed" Number to a Number
- Converting a "Stringed" Number to a Number
- sum cells with conditional formatting color
- Sum values entered into text boxes
- Data Sum rows not hidded
- Conditional Summing
- sum formula
- sum in columns
- Summing a range
- getting the sum of the last 20 cells
- Summing a range of variable size
- VBA code to sum
- Calculate Total Sum
- Sum colunm total in repeater
- sum of amount deliverd group
- count the sum of a column
- SUM content of rows
- custom Sum function?
- Loop, sum values and paste
- Getting the sum and percentage in Excel coulmn