Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array Formulas
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
array formulas in vba help | Excel Programming | |||
VB + array formulas | Excel Programming | |||
Array formulas | Excel Worksheet Functions |