counting problem

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:D500="<32")),--(D1:D500=">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

PvdG42
Fri Jul 18 10:09:10 CDT 2008

"kEV" <kEV@discussions.microsoft.com> wrote in message
news:7C3E9641-61B7-40AB-9CAA-8DD315804CF4@microsoft.com...
> 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:D500="<32")),--(D1:D500=">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/newsgroups/en-us/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.