Help using SUMIF and SUM in one cell

[LGexcel]

I am using the SUMIF function to add values in a column that meet the criteria of another column using this basic method:

=SUMIF(K9:K95,"Production General",M9:M95)

However, I want to include multiple 'K' columns and multiple 'M' columns from other Sheets within my Workbook.

I tried using this formula, but it is not working:

=SUMIF((SUM('January Log'!K9:K113,'February Log'!K9:K95,'March Log'!K9:K95,'April Log'!K9:K95,'May Log'!K9:K95,'June Log'!K9:K95,'July Log'!K9:K95,'August Log'!K9:K95,'September Log'!K9:K95,'October Log'!K9:K95,'November Log'!K9:K95,'December Log'!K9:K95)),"Production General",(SUM('January Log'!M9:M113,'February Log'!M9:M95,'March Log'!M9:M95,'April Log'!M9:M95,'May Log'!M9:M95,'June Log'!M9:M95,'July Log'!M9:M95,'August Log'!M9:M95,'September Log'!M9:M95,'October Log'!M9:M95,'November Log'!M9:M95,'December Log'!M9:M95)))

Can anyone suggest a better way, or point out the error(s) in my formula?

Many thanks!

[Haseeb Avarakkan]

Hello

Try this.

Please Login or Register  to view this content.

[LGexcel]

Works! Thank you so much!!