Sumproduct with sumif over mutiple worksheets

  • Thread starter Thread starter Zeddie_Burger
  • Start date Start date
Z

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!
 
Use SUMIF in the same cell on your Worksheets, then simply SUM your cell
across all Worksheets.
 
Hi,
=if(M40>1,B12+B22+B32+B42+L13+L33+L43,"")

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