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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only