Return Values to Summary Sheet

[ymerryweather]

This may be a simple question but I appreciate any guidance offered!

I have a workbook that contains and SUMMARY Worksheet and a CHARGE Worksheet. I'd like to set up a formula that returns certain information from the CHARGE Worksheet and adds it to the SUMMARY Worksheet. Column C on my CHARGE Worksheet contains the divisions that our employees are under and column F contains the amount of charges that month.

For example, on my CHARGE Worksheet, I have divisions CTVA, MAMD, NPNJ set up in Column C. In Column F, I have the associated charge amounts. Is there a formula that will return the charges that belong to only CTVA on my SUMMARY Worksheet? The CTVA cell on my SUMMARY Worksheet is G3.

Thank you in advance for any assistance

 

[jtakw]

Hi,

Use SUMIF:

Excel 2010
	C	D	E	F
1	CTVA			10
2	MAMD			20
3	NPNJ			30
4	MAMD			40
5	CTVA			50
6	CTVA			60
7	NPNJ			70
CHARGE

Excel 2010
	G	H
2		Total Charge
3	CTVA	120
4	MAMD	60
5	NPNJ	100
SUMMARY

Cell Formulas
Range	Formula
H3	=SUMIF(CHARGE!C$1:C$7,G3,CHARGE!F$1:F$7)

Formula copied down, adjust cell references to your data.