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 colunm total in repeater
- Calculate Total Sum
- sum of amount deliverd group
- count the sum of a column
- SUM content of rows
- custom Sum function?
- Summing a range of variable size
- Loop, sum values and paste
- VBA code to sum
- sum in columns
- Summing a range
- getting the sum of the last 20 cells
- Conditional Summing
- sum formula
- Sum values entered into text boxes
- Data Sum rows not hidded
- sum cells with conditional formatting color
- Compute the sum of both positive and negative elements of an array