Multiple criteria
 

Ok I have a workbook I am working on for someone else and my formulas will
not work. Any help would greatly be appreciated.
=SUMPRODUCT(--(C4:C59=5900),--(C4:C59<=5999)) this works like a charm but I
need to use this plus (e4:e59="g-shift"). I need the first formula to be the
condition to count the second formula. so basically i want if c4 has 5950
and E4 has g-shift then I get 1 and if e4 is blank then i get 0. Everything
I have tried says that the formula is wrong.

Multiple criteria
 

Did you try:

=SUMPRODUCT(--(C4:C59=5900),--(C4:C59<=5999),--(e4:e59="g-shift"))

If you did and it didn't work, what happened?

HeatherL43 wrote:

Ok I have a workbook I am working on for someone else and my formulas will
not work. Any help would greatly be appreciated.
=SUMPRODUCT(--(C4:C59=5900),--(C4:C59<=5999)) this works like a charm but I
need to use this plus (e4:e59="g-shift"). I need the first formula to be the
condition to count the second formula. so basically i want if c4 has 5950
and E4 has g-shift then I get 1 and if e4 is blank then i get 0. Everything
I have tried says that the formula is wrong.

--

Dave Peterson

Multiple criteria
 

This worked like a charm on all but one catagory. I think i am just doing
something wrong. i have one that has three sets of critereia. I tried this
but it just shows the word value . Thanking you in advance for your help.

=SUMPRODUCT(--(C4:C59=1),--(C4:C59<=3000))+SUMPRODUCT(--(C4:C59=9000),--(C4:C59<=9999))--(E4:E59="g-shift")

"Dave Peterson" wrote:

Did you try:

=SUMPRODUCT(--(C4:C59=5900),--(C4:C59<=5999),--(e4:e59="g-shift"))

If you did and it didn't work, what happened?

HeatherL43 wrote:

Ok I have a workbook I am working on for someone else and my formulas will
not work. Any help would greatly be appreciated.
=SUMPRODUCT(--(C4:C59=5900),--(C4:C59<=5999)) this works like a charm but I
need to use this plus (e4:e59="g-shift"). I need the first formula to be the
condition to count the second formula. so basically i want if c4 has 5950
and E4 has g-shift then I get 1 and if e4 is blank then i get 0. Everything
I have tried says that the formula is wrong.

--

Dave Peterson

Multiple criteria
 

Not totally sure what you are trying to accomplish here, but did you
omit a comma?

HeatherL43 wrote:
This worked like a charm on all but one catagory. I think i am just doing
something wrong. i have one that has three sets of critereia. I tried this
but it just shows the word value . Thanking you in advance for your help.

=SUMPRODUCT(--(C4:C59=1),--(C4:C59<=3000))+SUMPRODUCT(--(C4:C59=9000),--(C4:C59<=9999))--(E4:E59="g-shift")

.... --(C4:C59<=9999))--(E4:E59="g-shift")
^

BTW adding the comma will make the logic say

"C4:C59 is between 1 and 3000, OR C4:C59 is between 9000 and 9999 AND
E4:E59='g-shift'"

....resulting in 0 (neither side of OR is true), 1 (1 side of OR is
true), or 2 (both sides of OR are true). Is this what you expect?


"Dave Peterson" wrote:

Did you try:

=SUMPRODUCT(--(C4:C59=5900),--(C4:C59<=5999),--(e4:e59="g-shift"))

If you did and it didn't work, what happened?

HeatherL43 wrote:
Ok I have a workbook I am working on for someone else and my formulas will
not work. Any help would greatly be appreciated.
=SUMPRODUCT(--(C4:C59=5900),--(C4:C59<=5999)) this works like a charm but I
need to use this plus (e4:e59="g-shift"). I need the first formula to be the
condition to count the second formula. so basically i want if c4 has 5950
and E4 has g-shift then I get 1 and if e4 is blank then i get 0. Everything
I have tried says that the formula is wrong.
--

Dave Peterson