| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif across mutiple sheets | Excel Worksheet Functions | |||
| can i.. do a COUNT through mutiple worksheets? | Excel Discussion (Misc queries) | |||
| my sumif statement brings back mutiple answers, how do I fix it? | Excel Worksheet Functions | |||
| SUMif or SUMproduct across multiple worksheets? | Excel Worksheet Functions | |||
| SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
Hybrid Mode
