Maybe a pivot table... not sure

scrupul0us

Well-known Member
Joined
Sep 7, 2004
Messages
641
OK... this is a view of my final sheet that i need to display some sums on:
data.xls
ABCDEFGHIJK
110111213202122235090
2ADMIN OVERTIME
3ADMIN WAGES
4BEREAVEMENT
5BONUS
6DOUBLE TIME (2.0)
7ESA CONTRACT
RESULTS
 

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.
I had to limit the number of "wage type desc" in col A caus of post limits but you get the idea
row 1 is all the departments

ok... now on my other sheet "DATA" i have some columns:

G: "Wage Type Desc" with all the possible wage types
K: "Gross amount"
L: "Dept"

What i need todo is sum all the gross amounts by wage type by department put them in the above table

any help is apprecited
 
Upvote 0
Certainly sounds like you could use a pivot.

You could use Dept as a column item, Wage Type Desc as a row item and sum of Gross amount as a data item.
 
Upvote 0
ko well id id that...and for some reasonits not using the gross amount numbers... its all whole numbers... i even tried deleting the irrelevant columns in the data sheet and im still gettin off color results
 
Upvote 0
What do you mean it's not using them?
 
Upvote 0

Forum statistics

Threads
1,213,514
Messages
6,114,078
Members
448,547
Latest member
arndtea

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