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