<div>
Something is not clear here. Why did you select B1, B3 and B5? They dont have an S in their row, nor in the row above for all.
</div>


Something is not clear here. Why did you select B1, B3 and B5? They dont have an S in their row, nor in the row above for all.

Book1.xlsx

<div>
Thank you!!<br />
<br />
Perfect!! &nbsp;:-)
</div>


<div>
<div class="content wysiwyg-content">
Is there a way to average a cell if the cell above it has a crertain value??<br />
<br />
So if row b1 through b5 has percentages in it I want to add the cell and then give an average if in the row above the data has an S in it.<br />
<br />
A1 = S &nbsp;A2 = B A3 = S A4 = S A5 = B<br />
B1 = 2 B2 = 2 B3 = 7 B4 =9 B5 = 6<br />
<br />
Add B1+B3+B5 then average them. &nbsp;Total would change as the values in A change.
</div>
</div>


Is there a way to average a cell if the cell above it has a crertain value??

So if row b1 through b5 has percentages in it I want to add the cell and then give an average if in the row above the data has an S in it.

A1 = S  A2 = B A3 = S A4 = S A5 = B
B1 = 2 B2 = 2 B3 = 7 B4 =9 B5 = 6

Add B1+B3+B5 then average them.  Total would change as the values in A change.

excel 2007 help

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.