Hi!

See this screencap:

http://img141.imageshack.us/img141/2410/sump1pr.jpg

Just enter the formula in the first cell as depicted then copy it across
then down.

Biff

"XCESIV" wrote in
message ...

Here is a basic description of wat i am wanting to do
i have a spreadsheet of about 10 columns.

i need to get data from this sheet and cant do the math on it.

This can be simplified to this
I have A-location, B-department, C-cost
1 - front - cleaning - $100
2 - middle - service - $50
3 - front - admin - $200
4 - middle - manager - $110
5 - front - manager - $110
6 - back - assistant - $7
7 - middle - admin - $5
8 - front - cleaning - $50
9 - front - manager - $110
10 - middle - cleaning - $10

i want to add up all the sections seperatly.
how much money was costed to the cleaning in each location
EG - front cleaning $150
front manager $220
middle cleaning $10
back assistant $10

the positions and location will be changing every time this sheet is
used


--
XCESIV
------------------------------------------------------------------------
XCESIV's Profile:
http://www.excelforum.com/member.php...o&userid=24271
View this thread: http://www.excelforum.com/showthread...hreadid=537104