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
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

scrupul0us

Well-known Member
Joined
Sep 7, 2004
Messages
641
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
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,088
Office Version
  1. 365
Platform
  1. Windows
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.
 

scrupul0us

Well-known Member
Joined
Sep 7, 2004
Messages
641
well ill go play with the table... will be my first pivot table so im sure ill be back
 

scrupul0us

Well-known Member
Joined
Sep 7, 2004
Messages
641

ADVERTISEMENT

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
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,088
Office Version
  1. 365
Platform
  1. Windows
What do you mean it's not using them?
 

Watch MrExcel Video

Forum statistics

Threads
1,119,139
Messages
5,576,308
Members
412,716
Latest member
thviid
Top