<div>
Quick response, exactly what I needed. If you could do an overview of sumproduct function that would be very helpful as well.
</div>


Quick response, exactly what I needed. If you could do an overview of sumproduct function that would be very helpful as well.

<div>
You may find Microsoft Excel MVP Bob Phillip's web page on SUMPRODUCT to provide a good explanation of how it works: <a href="http://www.xldynamic.com/source/xld.SUMPRODUCT.html" rel="ugc">http://www.xldynamic.com/source/xld.SUMPRODUCT.html</a>
</div>


You may find Microsoft Excel MVP Bob Phillip's web page on SUMPRODUCT to provide a good explanation of how it works: http://www.xldynamic.com/source/xld.SUMPRODUCT.html [http://www.xldynamic.com/source/xld.SUMPRODUCT.html]

<div>
<div class="content wysiwyg-content">
I have an Excel worksheet (named &quot;Consolidated&quot;) where Column A is &quot;Date&quot;, Column B is called &quot;Type of Review.&quot; Each of these columns have different names and dates associated with them. In column F I have a value. So for example:<br />
Column A &nbsp; &nbsp; &nbsp; &nbsp;Column B &nbsp; &nbsp; &nbsp; &nbsp; Column F<br />
4/9/2012 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Type A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100<br />
4/9/2012 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Type B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50<br />
4/10/2012 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Type A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;110<br />
4/10/2012 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Type B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50<br />
<br />
Rather than run a Pivot Table, which I am aware of, I have a new worksheet (named &quot;Aggregate&quot;) where I am looking to sum/aggregate all of Column F by what it is labeled in Column B -- so here I would have Type A = 210 (regardless of the date) and Type B = 100. One of my colleagues recommended a sumproduct for getting this result. I am a beginner so detailed help would be useful and appreciated.
</div>
</div>


I have an Excel worksheet (named "Consolidated") where Column A is "Date", Column B is called "Type of Review." Each of these columns have different names and dates associated with them. In column F I have a value. So for example:
Column A        Column B         Column F
4/9/2012            Type A            100
4/9/2012            Type B             50
4/10/2012          Type A            110
4/10/2012          Type B             50

Rather than run a Pivot Table, which I am aware of, I have a new worksheet (named "Aggregate") where I am looking to sum/aggregate all of Column F by what it is labeled in Column B -- so here I would have Type A = 210 (regardless of the date) and Type B = 100. One of my colleagues recommended a sumproduct for getting this result. I am a beginner so detailed help would be useful and appreciated.

Microsoft Excel 2007 Formula Question

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.