Hi,
I am trying to come up with a formula that would add all the 06 numbers
with a code under 4.
Code 06 06 06 07 07 07
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 ="P" & Column 2 = "NAME"
SUM from Collumn 3

Thanks in advance

"neda5" wrote in message
...
Hi,
I am trying to come up with a formula that would add all the 06 numbers
with a code under 4.
Code 06 06 06 07 07 07
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

=SUMPRODUCT(--(A2:A200="P"),--(B2:B200="NAME"),C2:C200)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
...
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 ="P" & Column 2 = "NAME"
SUM from Collumn 3

Thanks in advance

"neda5" wrote in message
...
Hi,
I am trying to come up with a formula that would add all the 06 numbers
with a code under 4.
Code 06 06 06 07 07 07
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

=SUMPRODUCT((A1:E1=6)*(A2:E8<4)*(A2:E8))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"neda5" wrote in message
...
Hi,
I am trying to come up with a formula that would add all the 06 numbers
with a code under 4.
Code 06 06 06 07 07 07
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

A1 = "Thanks"*3

:)


"Bob Phillips" wrote in message
...
=SUMPRODUCT(--(A2:A200="P"),--(B2:B200="NAME"),C2:C200)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
...
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 ="P" & Column 2 = "NAME"
SUM from Collumn 3

Thanks in advance

"neda5" wrote in message
...
Hi,
I am trying to come up with a formula that would add all the 06 numbers
with a code under 4.
Code 06 06 06 07 07 07
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

Thanks. Can I make that formula to check only if the first column is less
than 4, not the whole table?

"Bob Phillips" wrote:

=SUMPRODUCT((A1:E1=6)*(A2:E8<4)*(A2:E8))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"neda5" wrote in message
...
Hi,
I am trying to come up with a formula that would add all the 06 numbers
with a code under 4.
Code 06 06 06 07 07 07
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