SUMIFS - using column & row criteria

[ErinP]

Is it possible to create a SUMIF formula using both a column and a row as criteria? I want to pull specific account information from one lalrge worksheet to another less detailed one. The columns include all the account numbers and the row headers show the different business units. I want to be able to pull the balance if the account # is 11111 and the business unit is ABC. I tried using the SUMIFS formula builder but got the #VALUE error.

I am not a very advanced Excel 2007 user, so any help or hints are very much appreciated.

 

[sunnyk]

Thanks and Sorry Mark! Being a new user, I was unaware of guidelines - so ended up posting my question in 3 related threads. Will create a new thread. Also, unable to delete the posts myself - so would request deletion.

 

[MARK858]

Click the report button at the bottom of one of your posts and explain the situation and one of the Moderators or Admin will look at whether to delete the threads.

Don't worry you aren't the first new poster to post without reading the rules or guidelines and they will understand