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


--
Regards
Dave Hawley
www.ozgrid.com
"Zeddie_Burger" wrote in message
...
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!