Avatar of Troy

asked on 

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


Would greatly appreciate if someone could please assist with the following sheet:


I have :

  1. A list of categories in column 'a' - Category A, Category B & Category C
  2. 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)
Microsoft OfficeMicrosoft ExcelGoogle Workspace

Avatar of undefined
Last Comment
Subodh Tiwari (Neeraj)

8/22/2022 - Mon