Formula to look up and sum cells based on multiple criteria in row and columns

[dookeykong]

I would like to create a formula in a summary sheet ("sheet 2 section" in attached)that looks up and sum cells based on multiple criteria in row and columns in "sheet 1 section". I thought I sumifs would work, but I kept getting #value errors. I'm not a power user in excel. Any help would be appreciated. I attached the spreadsheet - it is only an example of what I want to do as the real data is confidential and large. The result I should I get is in section 2. Lookup account 12.251 for tim in the month of February - result is 14.

Thank you.

Test2014.xlsxTest2014.xlsx

[Ron Coderre]

Using your posted workbook, this regular formula returns the sum of data items where the Account, Month, and Name match the criteria

Please Login or Register  to view this content.

Is that something you can work with?

[dookeykong]

Worked perfectly. I realized there were yes/no text within the numerical data that gave me #value errors. I just removed them as I did not need them and eureka! Thank you Ron!

[Ron Coderre]

Glad you got something you can use!

Please be sure to mark this thread as SOLVED (from the Thread Tools menu)