"kEV" <kEV@discussions.microsoft.comwrote in message
news:7C3E9641-61B7-40AB-9CAA-8DD315804CF4@microsoft.com...
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: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...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.
