| Forum Home | ||||
| PC World Chat | ||||
| Thread ID: 107217 | 2010-02-08 23:17:00 | Excel sumproduct help | stunt (15619) | PC World Chat |
| Post ID | Timestamp | Content | User | ||
| 856388 | 2010-02-08 23:17:00 | Hi, Could anyone assist me with this please? I am trying to get a count result for D2:D5 but its always giving me a sum result. That is, I want to know the number of scores in D2:D5 range that meets the first 3 criteria ((--(A2:A5=H3),--(B2:B5=K1),--(C2:C5=I3) Formula I have used is: =(SUMPRODUCT(--(A2:A5=H3),--(B2:B5=K1),--(C2:C5=I3),D2:D5)). Please help. Thanks, Stunt |
stunt (15619) | ||
| 856389 | 2010-02-08 23:27:00 | Have a look at the countif function. | Sweep (90) | ||
| 856390 | 2010-02-08 23:48:00 | yea tried it a couple of times and still doing but getting nowhere at the moment? | stunt (15619) | ||
| 856391 | 2010-02-12 10:25:00 | Hi Try this: =(SUMPRODUCT(--(A2:A5=H3),--(B2:B5=K1),--(C2:C5=I3)) or this (to count values in D2 : D5 > 0): =SUMPRODUCT(--(A2:A5=H3),--(B2:B5=K1),--(C2:C5=I3),--(D2 : D5>0)) The issue is that your existing function will sum the values in D2 : D5 that meet the criteria you specified. If you use the menu option : Tools > Formula Auditing > Evaluate Formula; then you can see what the formula is doing. Andrew |
andrew93 (249) | ||
| 1 | |||||