Hi Everyone,
Sorry to be hasty but I need help on this issue. I cannot wrap my head around this.
I need to consolidate my sums with two sepearate criteria on this excel sheet. I have my regions
Column A/B/C
Column A: Region
Column B: Class
Column C: The Data
Region 1/121/DATA
Region 1/122/DATA
Region 2/ 122/ DATA
Region 2/ 154/ DATA
Region 2/ 121/ DATA
Region 3...etc.
So I have DATA for different regions with different and sometines the same class. I have a list of criteria for the classes. for example 121 and 154 may be Class 1. 122 and etc...could be class 2.
Please Help!
Mr. Bank
Sorry to be hasty but I need help on this issue. I cannot wrap my head around this.
I need to consolidate my sums with two sepearate criteria on this excel sheet. I have my regions
Column A/B/C
Column A: Region
Column B: Class
Column C: The Data
Region 1/121/DATA
Region 1/122/DATA
Region 2/ 122/ DATA
Region 2/ 154/ DATA
Region 2/ 121/ DATA
Region 3...etc.
So I have DATA for different regions with different and sometines the same class. I have a list of criteria for the classes. for example 121 and 154 may be Class 1. 122 and etc...could be class 2.
Please Help!
Mr. Bank