|
 |  |  |  |  |  |  |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
 |
| |
07-18-2008
| #1 (permalink) |
| | counting problem "kEV" <kEV@xxxxxx> wrote in message news:7C3E9641-61B7-40AB-9CAA-8DD315804CF4@xxxxxx Quote: > Hi, > > I'm trying to count the number of instances a "house" for example in B1 > falls within a "rent" value of between >20 and <32 in D1 > and need to change instances to "flat" and ranges, please see example > below > Type RENT > House 58.98 > Flat 31.50 > Flat 36.50 > > answer would be count of 1 (flat with rent greater than 20 and less than > 32 > i'm trying to use > Sumproduct(--(B1:B500="house"),--(D1  500="<32")),--(D1500=">20"))> just > by reading other peop[les posts but am unable to get it to work despite > changing the formula slightly > > can anyone please help, greatly appreciated > thankyou in advance What product are you using? Excel by chance? If so, you need to find a group for the software you are using. Here's how to get there via the web interface: http://www.microsoft.com/communities...s/default.aspx Click the + beside your language. then scroll down to Office and Desktop Applications. In Office and Desktop Applications, find the category for the software you are using. Open it and find a group for your software to your question. |
My System Specs |
|
07-18-2008
| #2 (permalink) |
| | Re: counting problem "kEV" <kEV@xxxxxx> wrote in message news:7C3E9641-61B7-40AB-9CAA-8DD315804CF4@xxxxxx Quote: > Hi, > > I'm trying to count the number of instances a "house" for example in B1 > falls within a "rent" value of between >20 and <32 in D1 > and need to change instances to "flat" and ranges, please see example > below > Type RENT > House 58.98 > Flat 31.50 > Flat 36.50 > > answer would be count of 1 (flat with rent greater than 20 and less than > 32 > i'm trying to use > Sumproduct(--(B1:B500="house"),--(D1 500="<32")),--(D1500=">20"))> just > by reading other peop[les posts but am unable to get it to work despite > changing the formula slightly > > can anyone please help, greatly appreciated > thankyou in advance What product are you using? Excel by chance? If so, you need to find a group for the software you are using. Here's how to get there via the web interface: http://www.microsoft.com/communities...s/default.aspx Click the + beside your language. then scroll down to Office and Desktop Applications. In Office and Desktop Applications, find the category for the software you are using. Open it and find a group for your software to your question. |
| My System Specs |
|
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| counting file name | Vista file management | |||
| Re: 1 3/4 hour and counting | Vista General | |||
| Re: 1 3/4 hour and counting | Vista General | |||
| Re: 1 3/4 hour and counting | Vista General | |||
| RC-1 install - 6 hrs and counting | Vista installation & setup | |||
