Sumproduct with sumif over mutiple worksheets
 

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!

Sumproduct with sumif over mutiple worksheets
 

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!

Sumproduct with sumif over mutiple worksheets
 

Hi,
=if(M401,B12+B22+B32+B42+L13+L33+L43,"")

Formula will leave blank the cell if M40 is not 1

"Zeddie_Burger" wrote:

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!
.