Sumproduct with sumif over mutiple worksheets

[Zeddie_Burger]

Hello guys this is my first post.

I am having a issues with tracking information from multiple
worksheets in the same document

I have listed the names of each worksheets from O2:O127

I need to find a code that says if M40 is >1 then add up B12, B22,
B32, B42, L13, L33, L43 If not >1 then ignore.

Please help me!

 

[ozgrid.com]

Use SUMIF in the same cell on your Worksheets, then simply SUM your cell
across all Worksheets.

 

[Eduardo]

Hi,
=if(M40>1,B12+B22+B32+B42+L13+L33+L43,"")

Formula will leave blank the cell if M40 is not >1