HORISONTAL AND VERTICAL AREA IN SUMPRODUCT

E

emilija

Hi,
my problem is the following: I have an spread sheet as :
A B C
Cost Center 1. Cost Center 2. Cost Center 3.

1 Account1
2 Account2
3 Account2

My formula should look up for Cost Center No, and Account Number,
(horizontal and vertical areas) which is not possible by using SUMPRODUCT,
any suggestion?
 
O

Otávio

Hi, Emilija
I do not speak english so, be patient please.
I would like to know a little bit more:
1. WHERE will be located the formulas you want and WHERE will be the data.
2. In which row will be the column headers.
3. In which column will be the row headers.
Thanks
Otávio

"emilija" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Upload Center on Office 2010 when using encrypted area on disk 0
Making a vertical list from a rectangular range, with no empty lines 10
Excel formula help for calculating freight. 2
Creating Labels Over 3-Up Image 2
Linking two worksheets 3
Looking up in a table 3
Sumproduct Help! 3
help w indirect and index,match 3

Top