I am attempting to create a formula which returns the number of times a
value which occurs in G and is above certain values in F is presents.
Ie I have in Column F the outstanding balance of the client.
in column G the country they are in.
There are two ways I can see possible to get the output I wish being a
table which shows each country as Y and a range of debt as X e.g.
$500 $100 $50 $10
Albania x x x x
Cyprus x x x x
Malta x x x x
Now; I would of assumed that I can use COUNTIF but that is stressing me
out to no end, I have looked at PivotTables, which would be great if I
could create custom columns. (Can you do that?????)
So basicalli if I want to know how many debtors there are in Cyprus
$500 what would the formula be, ?
Excellent.
Thanks
--
samprince
------------------------------------------------------------------------
samprince's Profile:
http://www.excelforum.com/member.php...o&userid=34168
View this thread:
http://www.excelforum.com/showthread...hreadid=556036