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

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
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

R
  • Question
Best approach (VBA) to search through a sheet for all matches to a selected range (ie. multiple cells)?
Replies
2
Views
113
radiocam
R
P
  • Question
Trouble calculating unique values
Replies
0
Views
237
PETERFT73
P
G
  • Solved
Add total row with a loop
Replies
4
Views
173
gberg
G
F
  • Question
Rounding values to 2 decimel while keeping total 100%
2 3 4
Replies
38
Views
470
awoohaw
awoohaw
O
  • Question
Running through a Config and pulling out the relevant information using keywords into smaller sheets
Replies
0
Views
154
oitbc
O

Forum statistics

Threads
1,215,340
Messages
6,124,386
Members
449,155
Latest member
ravioli44

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