sum even and odd numbers in a range

You table setup is very Excel-like and doesn't lend itself to a compact solution.

However, you could try something like this, where the last to rows are defined as Footer Rows so you can put formulas in them that refer to the entire columns above:

The formula in D2, copied down the column, is =ISODD(C2)

The formula in F2, copied down into cells below it is, is =ISODD(E2)

The formula in C11 is:

=SUMIF(D,TRUE,C)+SUMIF(F,TRUE,E)

The formula in C12 is:

=SUM(C)+SUM(E)−C$11

If your region use , as a decimal separator use ; instead of , in the formulas.

SG

Hi Shadedlight,

Separate the odd and even values into other tables.

Formula in A2 of the Odds table IF(ISODD(Table 1::C2),Table 1::C2,"")

Fill right and fill down.

Formula in A2 of the Evens table IF(ISEVEN(Table 1::C2),Table 1::C2,"")

Fill right and fill down.

Formula in C11 of Table 1 SUM(Odds::A2:B9)

Formula in C12 of Table 1 SUM(Evens::A2:B9)

You can move (Cut and Paste) the Odds and Evens tables to another Sheet.

If you use Footer rows, these formulas can refer to whole columns and will automatically adjust as you add more rows.

Please reply with questions.

Regards,

Ian.

With the introduction of REGEX, we can use SUMIF to sum up even or odd integers

odds =SUMIF(C2:D8,REGEX("^\d*[13579]$"))

evens =SUMIF(C2:D8,REGEX("^\d*[02468]$"))

I read the description for SUMIF, saw it now takes regular expressions, and got the expressions from the Internet.