From Table Create a summary table with vlookup??

amolvijay

Board Regular
Joined
Nov 13, 2012
Messages
101
Office Version
  1. 365
Platform
  1. Windows
Hi Team,

I have set of data, which goes by name on month-on-month basis. The names have designation...

I want to see count of designation based on the set of name data...

A,B,C is master data. E,F is related designation. J,K,L,M is result table. Please help

ABCDEFGHIJKLM
1​
JULAUGSEPNameRoleJULAUGSEP
2​
AmolAmolAmolAmolSr.ManagerSr.Manager111
3​
AmitAmitAmitAmitManagerManager111
4​
AkhilAkhilAkhilAkhilDeveloperTech Lead111
5​
NavyaNavyaNavyaNavyaDeveloperDeveloper444
6​
BaishaliBaishaliBaishaliBaishaliTech LeadSr.Developer11
7​
YogeshYogeshYogeshYogeshDeveloperTester1
8​
ChetanChetanChetanChetanDeveloperTotal987
9​
PavanPavanPavanSr.Developer
10​
KanishtikaKanishtikaTester
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
How about
Fluff.xlsm
ABCDEFGHIJKLM
1JULAUGSEPNameRoleJULAUGSEP
2AmolAmolAmolAmolSr.ManagerSr.Manager111
3AmitAmitAmitAmitManagerManager111
4AkhilAkhilAkhilAkhilDeveloperTech Lead111
5NavyaNavyaNavyaNavyaDeveloperDeveloper444
6BaishaliBaishaliBaishaliBaishaliTech LeadSr.Developer110
7YogeshYogeshYogeshYogeshDeveloperTester100
8ChetanChetanChetanChetanDeveloperTotal987
9PavanPavanPavanSr.Developer
10KanishtikaKanishtikaTester
11
Districts
Cell Formulas
RangeFormula
K2:M7K2=SUM(COUNTIFS(A:A,FILTER($E$2:$E$10,$F$2:$F$10=$J2)))
K8:M8K8=SUM(K2:K7)
 
Upvote 0
Solution
How about
Fluff.xlsm
ABCDEFGHIJKLM
1JULAUGSEPNameRoleJULAUGSEP
2AmolAmolAmolAmolSr.ManagerSr.Manager111
3AmitAmitAmitAmitManagerManager111
4AkhilAkhilAkhilAkhilDeveloperTech Lead111
5NavyaNavyaNavyaNavyaDeveloperDeveloper444
6BaishaliBaishaliBaishaliBaishaliTech LeadSr.Developer110
7YogeshYogeshYogeshYogeshDeveloperTester100
8ChetanChetanChetanChetanDeveloperTotal987
9PavanPavanPavanSr.Developer
10KanishtikaKanishtikaTester
11
Districts
Cell Formulas
RangeFormula
K2:M7K2=SUM(COUNTIFS(A:A,FILTER($E$2:$E$10,$F$2:$F$10=$J2)))
K8:M8K8=SUM(K2:K7)
Thank you Fluff.... you rock....
 
Upvote 0
You're welcome & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,273
Members
448,559
Latest member
MrPJ_Harper

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