Sumif

[Fawn]

I have a workbook with 12 sheets in it. On the master page I want to sumif
all 12 sheets to get a Year to date recap. The columns that I need to sum
is total sales for the month. I could sum all the sheets together however
the information is not in the same order. On every sheet they are ranked
from highest sales to lowest sales.

If I use sumif, how do I write the formula to recap all 12 sheets or is
there another way of doing this.

Thanks for your help

 

[Peo Sjoblom]

What are the names of the 12 sheets (Jan, Feb and so on?)
What are the conditions in the sumif?


SUMPRODUCT(SUMIF(INDIRECT("'"&{"Jan";"Feb";"Mar";"Apr";"May";"Jun";"Jul";"Au
g";"Sep";"Oct";"Nov";"Dec"}&"'!A2:A10"),"a",INDIRECT("'"&{"Jan";"Feb";"Mar";
"Apr";"May";"Jun";"Jul";"Aug";"Sep";"Oct";"Nov";"Dec"}&"'!B2:B10")))

or assume you want to sum values in B2:B10 greater than 50


=SUMPRODUCT(SUMIF(INDIRECT("'"&{"Jan";"Feb";"Mar";"Apr";"May";"Jun";"Jul";"A
ug";"Sep";"Oct";"Nov";"Dec"}&"'!B2:B10"),">50"))