URGENT! Need HELP ASAP

mr.bank

New Member
Joined
Nov 4, 2009
Messages
13
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
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Maybe
in D1
=SUMPRODUCT((A1:A100=E1)*(B1:B100=F1)*(C1:C100))
and copy down

where
E1 Region
F1 Class

or possibly Pivot Tables?
 
Upvote 0
I have thought about pivot tables. However, this will be a template and the same information will not appear on any report.

For example I will have different classes that appear. I have a table that sums up all the classes.

Example

Class 1: 1 , 2, 3, 4,
Class 2: 5,6,7,8,
etc.

the above soultion you propose will not work, but I do appreciate the response.
 
Upvote 0
Why wouldn't a pivot table work?

One of the reasons you might use one is because of what you describe - with a pivot table you wouldn't need lists of the classes/whatever.

Just make sure you use the correct range.
 
Upvote 0

Forum statistics

Threads
1,223,243
Messages
6,170,971
Members
452,371
Latest member
Frana

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