Help needed with formula

[zphanes17]

First off I am new as of today to this board. Thank you in advance for your help. I know a little about excel but when it come to completing advanced formulas I need help.

I am creating a set of three sheets for my company to help track our rental equipment and costs yearly. I currently have the sheets made up and I am trying to figure out how to finish the cost tracking potion. I have a column that has our tracking code for each style of equipment and would like for the sheet to total all costs associated with that code into another common column for all costs with that code.

Sheet2: Closed rentals
https://drive.google.com/open?id=1IEybV0Dne3kDUN1jZdly2gzCBtWcRVP0
This is my current set up.

From there I would like to have those costs transfer to another sheet to simplify the cost breakdown. If there are steps that can be removed I am open to any help. If I don't need to have the costs total on sheet2 I would prefer not to have them there. I am only looking for total costs on sheet3. I have renamed my sheets but to simplify I have labeled them 1,2, and 3.

Sheet3 Costs:
https://drive.google.com/open?id=1QRG0CcI8FCEVc0Kdtg1FddkjRDV9m-4K

 

[jtakw]

Hi,

If I'm understanding correctly...
Assuming the "Cost" is in your Sheet 2 Column K, this will give you the Total Cost in Sheet 3 Column C using your SCEI ID as criteria:

Book1
	C
2	0
Sheet3

Cell Formulas
Range	Formula
C2	=SUMIF(Sheet2!B2:B100,B2,Sheet2!K2:K100)

Adjust formula cell range to include all your data, (i.e. B2:B100, K2:K100 to B2:B1000, K2:K1000, etc.)

 

[zphanes17]

That's helpful but not entirely what I am after.

I would like to use all costs with codes to total together in sheet3.

Example would be:
SCEI ID: CM in sheet2
I want all columns with code CM to be totaled together in row CM in sheet 3

Sheet2:
https://drive.google.com/open?id=1Ey3HBxs-DvDRi_sl6tRxqeAp8FxJjQuz

Sheet3:
https://drive.google.com/open?id=1AB9eg2QDzweb-vu_I2xVGn9op7-Ze6ed

 

[jtakw]

Hi,

That's what the formula does.
Although I did forget to add the absolute reference, and you need to copy the formula down Column C in Sheet 3.

Here, absolute references added:

Book1
	C
2	0
Sheet3

Cell Formulas
Range	Formula
C2	=SUMIF(Sheet2!$B2:$B1000,B2,Sheet2!$K2:$K1000)