Jobs Simply

Excell array formulay for multiple pages in a workbook?

Hi all... I have a sales order intake sheet which is spread across 12 pages (one for each month). In column A is the customer name and in column C is the order value for that job. I am trying to find a formular which can look at every occurance of a specific customer within the whole 12 months and add up all the respective order values. I am able to do this on a page by bage basis using this simple SUMIF formular ( SUMIF(A1:A1000,"Customer1",C1:I1000)) ). But that would meen adding loads more data to the work book as I would have to SUMIF each customer on every page meaning lot's of exess data and I am trying to keep the size of the sheet down becuse it gets emailed. Is their an array formular or something I can use which would allow me to do the above but for all 12 pages in one formular on a summary page rather than having to duplicate the same thing on each page and add it all up. Many thanks in advance Oscar100

Public Comments

1. I understand that you want a solution, but you have to elaborate more on what you wanna do, so that it's gonna be easy for the answerers. Provide information like: sample codes, the languages your using and others. Hope it helps ya next time.
2. It's certainly possible but not with any Excel formula I know about. You'd have to write some VBA code behind the worksheets.
3. If I take your formula =SUMIF(A1:A1000,"Customer1",C1:I1000) and change it slightly to =SUMIF(Sheet1!A1:A1000,"Customer1", Sheet1!C1:I1000) This formula can be placed on sheet 13 to sum the values on sheet1. With this in mind you can now extend this formula my having 12 indicidual SUMIF()'s to do the work. If you also make the "Customer1" a cell reference then you will only have to type the custmoer name into a cell for this to be a dynamic solution. =SUMIF(Sheet1!A1:A1000,"Customer1", Sheet1!C1:I1000) + SUMIF(Sheet2!A1:A1000,"Customer1", Sheet2!C1:I1000) Hope this helps.