Jun 29 2022 08:37 AM
I have an Excel sheet each tab is a month, last tab is overview. on Each tab is 3 names, each name has 3 tiers A, B, C and 2 types within those tiers Formal or Touch. ColumnB is person, ColumnC is Tier, ColumnG is Formal or Touch. I need to be able to write a formula for the overview page that can pull that month, each person, how may of each tier, and each type so they see their breakdown. Overview has Jan-Dec in column C-N. Person 1 Tier A Jan total go in C2, Tier B C3, Tier C4, Formal C6, Touch, C7. the Second person Jan total start in C9 and the 3rd in C16. Can you help??
Jun 29 2022 08:57 AM
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
Jun 29 2022 09:38 AM
Yes? Did you intend to attach a file or post a link?
Jun 29 2022 10:01 AM
Jun 29 2022 11:25 AM
Your data are very inconsistent:
Peron1, Person1, Person 1
"A", "A "
"Formal ", "Formal"
etc. I tried to correct that the best I could, and added formulas.
Jun 29 2022 11:44 AM