Troy

<div>
Norie - brilliant, thanks <em>so&nbsp;</em>much!<br><br>Have updated the question and the sheet with:<br><br>If there are many 'Categories' - can the formula please get all of the descriptions and put them in Column D?<br><br>(have updated the sheet accordingly)<br><br><br><br><br>
</div>


<div>
Brilliant and quick response, thank-you both!
</div>


<div>
Subodh - thank-you!<br><br>That is another great solution, thanks, appreciate it!👍😊<br><br>
</div>


<div>
<div class="content wysiwyg-content">
Hi!<br />
<br />
Would greatly appreciate if someone could please assist with the following sheet:<br />
<br />

<div class="indent"></div>
<a href="https://docs.google.com/spreadsheets/d/1p2ECh3mBaFyqLdt3mloevs2FOqWdsJeP2M5vTNv_Yr0/edit?usp=sharing" rel="ugc">https://docs.google.com/spreadsheets/d/1p2ECh3mBaFyqLdt3mloevs2FOqWdsJeP2M5vTNv_Yr0/edit?usp=sharing</a><br />
<br />
I have :<br />
<br />

<ol type="1">
<li>A list of categories in column 'a' - Category A, Category B &amp;&nbsp;Category C</li>
<li>Amounts in column 'b'</li>
</ol>
<br />
I need to use (sorry, not sure which!) I think Sub Total or Consolidate Data function of Google Sheets to:<br />
<br />
<b>Sum</b> the amounts for Category A, Category B &amp;&nbsp;Category C<br />
<br />
in cells E4, E5 &amp;&nbsp;E6<br />
<br />
Hoping you can assist, thanks so much in advance!<br />
<br />
PS - and if there are many 'Categories' - can the formula please get all of the description and put them in Column D?<br />
<br />
(have updated the sheet)
</div>
</div>


Hi!

Would greatly appreciate if someone could please assist with the following sheet:

https://docs.google.com/spreadsheets/d/1p2ECh3mBaFyqLdt3mloevs2FOqWdsJeP2M5vTNv_Yr0/edit?usp=sharing

I have :

A list of categories in column 'a' - Category A, Category B & Category C
Amounts in column 'b'


I need to use (sorry, not sure which!) I think Sub Total or Consolidate Data function of Google Sheets to:

Sum the amounts for Category A, Category B & Category C

in cells E4, E5 & E6

Hoping you can assist, thanks so much in advance!

PS - and if there are many 'Categories' - can the formula please get all of the description and put them in Column D?

(have updated the sheet)

Subtotal function in Excel of the numbers in a column in a list

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.

Microsoft Excel

Google Workspace is a suite of cloud computing productivity and collaboration software tools and software. It includes Google’s popular web applications including Gmail, Drive, Hangouts, Calendar, and Docs. While these products are available to consumers free of charge, Google Workspace adds business-specific features such as custom email addresses at your domain and storage for documents and email.