software

Hi,
I am trying to come up with a formula that would add all the 06 numbers
with a code under 4.
Code060606070707
1 - - - - - -
2 - 5 - - - -
3 - 5 7 - - -
4 - 5 7 - - -
5 - 5 - 7 7 -
6 - 3 7 - 7 -
7 - 2 7 - 7 -

Can anyone help me?
Thanks in advance.
Neda

Unfortunately I don't have your solution, but I do have a similar question,
so forgive me for Piggy-Backing on your question

I need to do a SUMIF with 2 conditionals as well, unfortunately, mine are in
2 seperate arrays. One array has a letter, I want to:
SUMIF()
IF Column 1 =quot;Pquot; amp; Column 2 = quot;NAMEquot;
SUM from Collumn 3

Thanks in advance

quot;neda5quot; gt; wrote in message
...
gt; Hi,
gt; I am trying to come up with a formula that would add all the 06 numbers
gt; with a code under 4.
gt; Code 06 06 06 07 07 07
gt; 1 - - - - - -
gt; 2 - 5 - - - -
gt; 3 - 5 7 - - -
gt; 4 - 5 7 - - -
gt; 5 - 5 - 7 7 -
gt; 6 - 3 7 - 7 -
gt; 7 - 2 7 - 7 -
gt;
gt; Can anyone help me?
gt; Thanks in advance.
gt; Neda
=SUMPRODUCT(--(A2:A200=quot;Pquot;),--(B2:B200=quot;NAMEquot;),C2:C200)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Adam Kroger @hotmail.comgt;quot; lt;adam_krogerlt;nospamgt; wrote in message
...
gt; Unfortunately I don't have your solution, but I do have a similar
question,
gt; so forgive me for Piggy-Backing on your question
gt;
gt; I need to do a SUMIF with 2 conditionals as well, unfortunately, mine are
in
gt; 2 seperate arrays. One array has a letter, I want to:
gt; SUMIF()
gt; IF Column 1 =quot;Pquot; amp; Column 2 = quot;NAMEquot;
gt; SUM from Collumn 3
gt;
gt; Thanks in advance
gt;
gt; quot;neda5quot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt; I am trying to come up with a formula that would add all the 06 numbers
gt; gt; with a code under 4.
gt; gt; Code 06 06 06 07 07 07
gt; gt; 1 - - - - - -
gt; gt; 2 - 5 - - - -
gt; gt; 3 - 5 7 - - -
gt; gt; 4 - 5 7 - - -
gt; gt; 5 - 5 - 7 7 -
gt; gt; 6 - 3 7 - 7 -
gt; gt; 7 - 2 7 - 7 -
gt; gt;
gt; gt; Can anyone help me?
gt; gt; Thanks in advance.
gt; gt; Neda
gt;
gt;
=SUMPRODUCT((A1:E1=6)*(A2:E8lt;4)*(A2:E8))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;neda5quot; gt; wrote in message
...
gt; Hi,
gt; I am trying to come up with a formula that would add all the 06 numbers
gt; with a code under 4.
gt; Code 06 06 06 07 07 07
gt; 1 - - - - - -
gt; 2 - 5 - - - -
gt; 3 - 5 7 - - -
gt; 4 - 5 7 - - -
gt; 5 - 5 - 7 7 -
gt; 6 - 3 7 - 7 -
gt; 7 - 2 7 - 7 -
gt;
gt; Can anyone help me?
gt; Thanks in advance.
gt; Neda
A1 = quot;Thanksquot;*3

quot;Bob Phillipsquot; gt; wrote in message
...
gt; =SUMPRODUCT(--(A2:A200=quot;Pquot;),--(B2:B200=quot;NAMEquot;),C2:C200)
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Adam Kroger @hotmail.comgt;quot; lt;adam_krogerlt;nospamgt; wrote in message
gt; ...
gt;gt; Unfortunately I don't have your solution, but I do have a similar
gt; question,
gt;gt; so forgive me for Piggy-Backing on your question
gt;gt;
gt;gt; I need to do a SUMIF with 2 conditionals as well, unfortunately, mine are
gt; in
gt;gt; 2 seperate arrays. One array has a letter, I want to:
gt;gt; SUMIF()
gt;gt; IF Column 1 =quot;Pquot; amp; Column 2 = quot;NAMEquot;
gt;gt; SUM from Collumn 3
gt;gt;
gt;gt; Thanks in advance
gt;gt;
gt;gt; quot;neda5quot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hi,
gt;gt; gt; I am trying to come up with a formula that would add all the 06 numbers
gt;gt; gt; with a code under 4.
gt;gt; gt; Code 06 06 06 07 07 07
gt;gt; gt; 1 - - - - - -
gt;gt; gt; 2 - 5 - - - -
gt;gt; gt; 3 - 5 7 - - -
gt;gt; gt; 4 - 5 7 - - -
gt;gt; gt; 5 - 5 - 7 7 -
gt;gt; gt; 6 - 3 7 - 7 -
gt;gt; gt; 7 - 2 7 - 7 -
gt;gt; gt;
gt;gt; gt; Can anyone help me?
gt;gt; gt; Thanks in advance.
gt;gt; gt; Neda
gt;gt;
gt;gt;
gt;
gt;
Thanks. Can I make that formula to check only if the first column is less
than 4, not the whole table?

quot;Bob Phillipsquot; wrote:

gt; =SUMPRODUCT((A1:E1=6)*(A2:E8lt;4)*(A2:E8))
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;neda5quot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt; I am trying to come up with a formula that would add all the 06 numbers
gt; gt; with a code under 4.
gt; gt; Code 06 06 06 07 07 07
gt; gt; 1 - - - - - -
gt; gt; 2 - 5 - - - -
gt; gt; 3 - 5 7 - - -
gt; gt; 4 - 5 7 - - -
gt; gt; 5 - 5 - 7 7 -
gt; gt; 6 - 3 7 - 7 -
gt; gt; 7 - 2 7 - 7 -
gt; gt;
gt; gt; Can anyone help me?
gt; gt; Thanks in advance.
gt; gt; Neda
gt;
gt;
gt;