Sumif

  • Thread starter Thread starter Fawn
  • Start date Start date
F

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
 
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"))
 
Back
Top