Multiple criteria

[HeatherL43]

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]

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]

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")