Array Formulas
Mr. Bob.
How are you doing? I hope fine.
I need your help.
i have 10 excel sheets in one work book. And in each excel sheets there is
some data.
the name of the sheets are as follows:
01-May, 02-May, 03-May, 06-May as so on....
Now i want to merge all the data in different excel sheet in which there is
only one sheet, i.e. monthly data..
THE EXCEL SHEET IS LIKE THIS:
A B C D E F G
H I
1 01May ?
2 02May ?
3 03May ?
4 04May ?
5 05May ?
6 06May ?
Now in place of the "?" mark ,,i want those data. So how i can link these
two excel different workbook.
Please help me.
Thanks & Regds
Neeraj
"Bob Phillips" wrote:
Try
=SUMPRODUCT(--(ActName=A8),--(Month=C1),Sheet1!E1:E1000)
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
wrote in message
...
Hi
hopefully someone can help!
Im trying to return a sumif using two constants, Desc & Month
Act Name Month
Column A Column B Column E
Hat Feb 08 1000.00
T Shirt Mar 08 2500.00
Hat Mar 08 2300.00
I have tried various examples and they always seem to work, but when I
try using the formula given within my own spreadsheet I get a #Num
error.
=SUM(IF((ActName=A8)*(Month=C1),Sheet1!E1:E1000))
The core data is quite long 500 rows so I have named the columns
(ActName, Month) although I Havent named the column with the numbers
in that I want to sum
The only difference I can see between my sheet and the many examples,
is that column A & B on mine are links from other workbooks. And I
need the result on a different sheet, as I am trying to summarise a
cashflow
Is this the problem and if so does anyone know how to get round it.
I had never used array formulas until I started investigating how to
do this so I may be going about it the completely wrong way.
Any help would be gratefully received.
Thanks in advance
Mags
|