Prev: Use Vlookup to store formulas?
Next: SumIf
From: Zeddie_Burger on 13 Apr 2010 22:50
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!
From: ozgrid.com on 13 Apr 2010 23:06
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" <zaneta.howell(a)gmail.com> wrote in message
news:e85dcd67-ba88-41aa-bf53-af0bff58baa7(a)u21g2000yqc.googlegroups.com...
> 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!

From: Eduardo on 14 Apr 2010 08:18
Hi,
=if(M40>1,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!
> .
>
 | 
Pages: 1
Prev: Use Vlookup to store formulas?
Next: SumIf