Sumifs with a data offset

Question

Hello - I need help with a sumif equation.

I am transferring a set of file between two excel files but they have different formats. I would like to use a sumif because I need to match three criteria 1) Area(ex Inner RH, Inner LH) 2) Utility(Electricity, Natural Gas, Water) 3) Category (Breakdowns, Setup Reg and Adj)

The issue is the first criteria Area has multiple columns in one file. Here is the file I would like to transfer the data to and input the formula. The cells range are D14:M16

Category	Utility	INNER RH	INNER LH	OUTER RH	OUTER LH	FRAMING 2	UNDERBODY FRAMING	FRAMING 1	FRAMING 2
BREAKDOWNS	Electricity
SET UP, REGULATIONS & ADJUSTMENTS	Electricity

Here is the file I am pulling data from

ENERGY		INNER RH	INNER LH	INNER RH	INNER LH	OUTER RH	OUTER LH	FRAMING 2	FRAMING 2
Category	Utility	APR_INR_RH	APR_INR_LH	APR_RNF_RH	APR_RNF_LH	APR_OTR_RH	APR_OTR_LH	APR_FNL_RH	APR_LOOPR1
Breakdowns	Electricity	344	55	222	40	50	750	953	555

So if the equation I am looking for works correctly for Inner RH, Breakdowns, Electricity, I would get 566(344+222). Thank you for the help. Let me know if you have any questions.

Answer 1

Frankly, I can't make much out of what you have pasted here.

If you don't get a solution you can use, then send me the two files with a clear explanation of what you want to do.

http://tinyurl.com/27hf3kh

is my google profile. Once there, click on my email address and after typing in the word displayed see my email address

--

Regards,

Tom Ogilvy