I am using Excel 2007
Am trying to make a workbook with 10 worksheets. Sheets 1-9 are the same format, each with 12 columns, all the same layout. I want to SUM summarize onto sheet 10 a column from the other sheets, the criteria being that a col on each sheet (Catcode) has the same number as a col (Catno) on sheet 10. The formula I am trying to use in each cell of the Sheet10 cols is:
SUMIF('Database1.xlsm'!Catcode,sheet10!Catno,'Database1.xlsm'!TP)
Catcode is =Sheet1:Sheet9!$B$4:$B$41
Catno is =Sheet10!$A$4:$A$58
TP is =Sheet1:Sheet9!$KK$4:$K$41
I have tried saving the formula as an array (Ctrl-SH-Enter) but to no effect. I get #VALUE in each cell.
If I succeed I will be expanding the size of each Sheet 1-9 to a possible 3000 rows each.
Any help would be welcome
Billirl
Bookmarks