<div>
Hi,<br />
<br />
Your question is quite confusing.<br />
<br />
You want a formula to check each cell in the whole of Column B (B:B which would be just over a million cells if working on an xlsx format), and sum up column C from the corresponding cells if the cell in B equals whatever is in N6?<br />
<br />
However, in your example, you use a fixed value of '6'.<br />
<br />
Do you mean cell N6 or a fixed value of 6?<br />
<br />
Also, your example includes a final result of 2 + 20 = 20. &nbsp;Is that a typo, or do you mean you want to return the largest value from any corresponding cell in Column C (which in your example is 20).<br />
<br />
<br />
Please clarify and / or correct any typos.<br />
<br />
Thanks,<br />
<br />
Alan.
</div>


Hi,

Your question is quite confusing.

You want a formula to check each cell in the whole of Column B (B:B which would be just over a million cells if working on an xlsx format), and sum up column C from the corresponding cells if the cell in B equals whatever is in N6?

However, in your example, you use a fixed value of '6'.

Do you mean cell N6 or a fixed value of 6?

Also, your example includes a final result of 2 + 20 = 20.  Is that a typo, or do you mean you want to return the largest value from any corresponding cell in Column C (which in your example is 20).


Please clarify and / or correct any typos.

Thanks,

Alan.

<div>
I think you need this...<br />
<br />

<pre><code id="code-20-42483529-1">=SUMIF(B:B,N6,C:C)</code></pre>
</div>


I think you need this...



=SUMIF(B:B,N6,C:C)

<div>
Thanks everyone for the support :) the formula i needed was the =SUMIF(B:B,6,C:C)
</div>


Thanks everyone for the support :) the formula i needed was the =SUMIF(B:B,6,C:C)

<div>
<div class="content wysiwyg-content">
I need an excel formula that looks across a row and evaluates if (B:B) contains N6 then sums all values in row into D2. e.g. &nbsp;if | B2 = 6 and C2 &nbsp;= 2 | , &nbsp;B4 = 6 and C4 = 20 | then D2 = C2+C4 or 2+20 = 20. If you need further information please ask. Thanks in advance :)
</div>
</div>


I need an excel formula that looks across a row and evaluates if (B:B) contains N6 then sums all values in row into D2. e.g.  if | B2 = 6 and C2  = 2 | ,  B4 = 6 and C4 = 20 | then D2 = C2+C4 or 2+20 = 20. If you need further information please ask. Thanks in advance :)

If Cell B2 and B4 equals 6 then sum C2 and C4 into D2

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 Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

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