| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
