# Software

## Question

Locked

### Excel - Sum and Average every other row

By ·
I have an Excel spreadsheet that has data in every other row starting in cell C2 and ending in cell C62. I am trying to get my spreadsheet to calculate the average of all of the data in these cells. I know how to do an average formula, but I don't know how to tell Excel to only average cells C2, C4, C6... C62 and ignore C1, C3, C5... C61. The odd numbered cells have other things in them, sometimes words, sometimes other numbers. So I can't just say "=AVERAGE(C1:C62)". Please help when you have a chance.
Thanks.

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)
| Thread display: Collapse - | Expand +

Collapse -

### Excel does that for you

by In reply to Excel - Sum and Average e ...

You can say =Average(c1:C62) provided that you do not have any values in the odd number cells.

Collapse -

### Average every other cell

by In reply to Excel - Sum and Average e ...

=AVERAGE(C1:C62)is fine unless you have data between each cell. If so, simply determine which cells you want to avg by means of odd or even rows as such:
=IF(MOD(ROW(D22),2)=0,AVERAGE(C1)," ")
then just drag the formula down ......
good luck

Collapse -

### Sum and Average every other row

by In reply to Excel - Sum and Average e ...

BTW the summation of every other row would be similar:
=IF(MOD(ROW(D22),2)=0,SUM(\$C1/\$C62)," ")

Also...this example would resolve for data in even # rows. For Odd rows:
=IF(MOD(ROW(D22),2)=1,SUM(\$C1/\$C62)," ")

4 total posts (Page 1 of 1)

## Related Discussions

• 12

#### Is AppVn working Fine?

appvnstore02 //

• 1

#### The perfect mail backup tool

andrewhogg458 //

• 0

#### Gaming Internet/Cyber Cafe image Deployment Software

3bspeedy10 //

• 2

#### Problems running Photoshop

rebeccaconley //

• 1

#### Recommended e-Mail based learning system

Christo Vorster //