Tom,
Color me stupid, but I couldn't get this to work.

Give me a simple example. If a1-a10 contain values I'm interested in and I wish to total a2, a4, a6, a8, and a10 and then display the result in a11, what formula do I put in a11?

Thanks!
Tom.
>Tom,
>
>Sorry, I used forbidden characters.
>
>You will have to create a criteria range to test the rows. I use
>MOD(,2). To get a total of the amounts in
>even numbered cells, enter SUMIF(,0, )
>in the cell where you want to put the summary data. If you want to total
>odd numbered cells, change the 0 to 1.
>It works.
>
>
>Tom Molloy