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

=COUNTIF(G:G,H:H)

as shown in your example.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"samprince" wrote
in message ...

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

Have you tried using an inequality in your expression?

=countif(b2:z2,"500")

HTH
Owen

Bob Phillips wrote:
=COUNTIF(G:G,H:H)

as shown in your example.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"samprince" wrote
in message ...

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

I need the forumula to return the fequency of occurences as opposed to
the Sum of all the occurences [=

that seems to be the hard part.


--
samprince
------------------------------------------------------------------------
samprince's Profile: http://www.excelforum.com/member.php...o&userid=34168
View this thread: http://www.excelforum.com/showthread...hreadid=556036

Isn't that what are responses gave?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"samprince" wrote
in message ...

I need the forumula to return the fequency of occurences as opposed to
the Sum of all the occurences [=

that seems to be the hard part.


--
samprince
------------------------------------------------------------------------
samprince's Profile:
http://www.excelforum.com/member.php...o&userid=34168
View this thread: http://www.excelforum.com/showthread...hreadid=556036

=Sumif adds together the value of the occurences

\- :

I need the frequency. i.e a =Countif forumula.


--
samprince
------------------------------------------------------------------------
samprince's Profile: http://www.excelforum.com/member.php...o&userid=34168
View this thread: http://www.excelforum.com/showthread...hreadid=556036

=SUMIF(G:G,"Albania",H:H)

as shown in your example

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"samprince" wrote
in message ...

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