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