Add specific text in one sheet, put the total on another

M

MrSuperConfused

New Member
Joined
Nov 5, 2019
Messages
9
I have 17 text values total. They are broken down into 2 groups. 11 in one (group A), 6 in another (group B).
All values are in a single column on one worksheet, many are listed multiple times.
Starting at D2 going down to D150.
I want to count the sum of one group within that column and total it on a separate worksheet within the same workbook.
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Sort by date Sort by votes
Please Upload your example file & Desired Results with XL2BB ADDIN (Preferable) or upload at free hosting site e.g. www.dropbox.com , GoogleDrive or Onedrive and Insert Link here.
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question
Trouble calculating unique values
Replies
0
Views
229
PETERFT73
P
G
  • Solved
Add total row with a loop
Replies
4
Views
120
gberg
G
O
  • Question
Running through a Config and pulling out the relevant information using keywords into smaller sheets
Replies
0
Views
119
oitbc
O
Sweedler
  • Solved
Comparing cells in column loop
Replies
2
Views
208
Sweedler
Sweedler
D
  • Question
Separate data and text from one cell to provide a duration with a summary
Replies
7
Views
275
BrerRabbit
B

Forum statistics

Threads
1,214,524
Messages
6,120,049
Members
448,940
Latest member
mdusw

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top