HORISONTAL AND VERTICAL AREA IN SUMPRODUCT
 

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?

HORISONTAL AND VERTICAL AREA IN SUMPRODUCT
 

Hi, Emilija
I do not speak english so, be patient please.
I would like to know a little bit mo
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:

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?