counting problem

  • Thread starter Thread starter kEV
  • Start date Start date
K

kEV

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
 
kEV said:
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
Click to expand...


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.
 
Back
Top