Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count multiple cells against multiple criteria in an Excel spreads | Excel Worksheet Functions | |||
match multiple criteria ina range from multiple criteria multiplet | Excel Worksheet Functions | |||
Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions |