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?
 
G

Guest

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

Making a vertical list from a rectangular range, with no empty lines 10
Vlookup or Hlookup does not work 1
Linking two worksheets 3
Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
How do I use multiple criteria with sumif in Excel? 2
Sumproduct Help! 2
SUMPRODUCT DUPLICATES 2
Will sumproduct work? 1

Top