Need to add a column that has either a "P" or an "X". I can figure out how
to add "p's" or "x's"( =COUNTIF(D2:D65,"p") but not both ("p and/or x").
It was suggested I use the countif.

Suggestions and thanks,


L.

"L/P" wrote in message
...
Need to add a column that has either a "P" or an "X". I can figure out how
to add "p's" or "x's"( =COUNTIF(D2:D65,"p") but not both ("p and/or x").
It was suggested I use the countif.

Err,

=COUNTIF(D2:D65,"p")+COUNTIF(D2:D65,"x")

, ?

HTH,
Andy

One way:

=SUM(COUNTIF(D2:D65,{"p","x"}))

HTH
Jason
Atlanta, GA

-----Original Message-----
Need to add a column that has either a "P" or an "X". I
can figure out how
to add "p's" or "x's"( =COUNTIF(D2:D65,"p") but not
both ("p and/or x").
It was suggested I use the countif.

Suggestions and thanks,


L.


.

WOW- thanks.

Have a great new year.

L.

"Jason Morin" wrote in message
...
One way:

=SUM(COUNTIF(D2:D65,{"p","x"}))

HTH
Jason
Atlanta, GA

-----Original Message-----
Need to add a column that has either a "P" or an "X". I
can figure out how
to add "p's" or "x's"( =COUNTIF(D2:D65,"p") but not
both ("p and/or x").
It was suggested I use the countif.

Suggestions and thanks,


L.


.

Here's another problem I can't figure out.

I have made a monthly "deposit" sheet with:

A B C D E
F G H

1 Units $ Due Deposit # 1 Deposit # 2
Deposit # 3
2 Amount Paid Amount Paid
Amount Paid
3 1203 $500
4 1204 $600
5 1205 $450
..
..
63 1263 $500
64 1264 $450

When a correct deposit is made in Amount (column C,E or G) I want a "P"
inserted in column D, F or H. If not correct amount "X". The formula I came
up with would be =IF(C3=B3,"p","x").
Problem is that the entire sheet starts out with x's.....
Trying to get a blank in columns D, F and H until something is entered in
columns C,E or G.

Help please, the entire sheet is filled with x's and each unit only makes
one deposit a month.

L.




"L/P" wrote in message
...

WOW- thanks.

Have a great new year.

L.

"Jason Morin" wrote in message
...
One way:

=SUM(COUNTIF(D2:D65,{"p","x"}))

HTH
Jason
Atlanta, GA

-----Original Message-----
Need to add a column that has either a "P" or an "X". I
can figure out how
to add "p's" or "x's"( =COUNTIF(D2:D65,"p") but not
both ("p and/or x").
It was suggested I use the countif.

Suggestions and thanks,


L.


.

=IF(C3="","",IF(C3=B3,"p","x"))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"L/P" wrote in message
...

Here's another problem I can't figure out.

I have made a monthly "deposit" sheet with:

A B C D E
F G H

1 Units $ Due Deposit # 1 Deposit # 2
Deposit # 3
2 Amount Paid Amount Paid
Amount Paid
3 1203 $500
4 1204 $600
5 1205 $450
.
.
63 1263 $500
64 1264 $450

When a correct deposit is made in Amount (column C,E or G) I want a "P"
inserted in column D, F or H. If not correct amount "X". The formula I
came
up with would be =IF(C3=B3,"p","x").
Problem is that the entire sheet starts out with x's.....
Trying to get a blank in columns D, F and H until something is entered in
columns C,E or G.

Help please, the entire sheet is filled with x's and each unit only makes
one deposit a month.

L.




"L/P" wrote in message
...

WOW- thanks.

Have a great new year.

L.

"Jason Morin" wrote in message
...
One way:

=SUM(COUNTIF(D2:D65,{"p","x"}))

HTH
Jason
Atlanta, GA

-----Original Message-----
Need to add a column that has either a "P" or an "X". I
can figure out how
to add "p's" or "x's"( =COUNTIF(D2:D65,"p") but not
both ("p and/or x").
It was suggested I use the countif.

Suggestions and thanks,


L.


.

Again, thanks.

Is there a good simple to understand book out there I could get that would
help me?
The HELP menu apparently can't. :-)

L.

"Bob Phillips" wrote in message
...
=IF(C3="","",IF(C3=B3,"p","x"))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"L/P" wrote in message
...

Here's another problem I can't figure out.

I have made a monthly "deposit" sheet with:

A B C D E
F G H

1 Units $ Due Deposit # 1 Deposit # 2
Deposit # 3
2 Amount Paid Amount Paid
Amount Paid
3 1203 $500
4 1204 $600
5 1205 $450
.
.
63 1263 $500
64 1264 $450

When a correct deposit is made in Amount (column C,E or G) I want a "P"
inserted in column D, F or H. If not correct amount "X". The formula I
came
up with would be =IF(C3=B3,"p","x").
Problem is that the entire sheet starts out with x's.....
Trying to get a blank in columns D, F and H until something is entered
in
columns C,E or G.

Help please, the entire sheet is filled with x's and each unit only
makes
one deposit a month.

L.




"L/P" wrote in message
...

WOW- thanks.

Have a great new year.

L.

"Jason Morin" wrote in message
...
One way:

=SUM(COUNTIF(D2:D65,{"p","x"}))

HTH
Jason
Atlanta, GA

-----Original Message-----
Need to add a column that has either a "P" or an "X". I
can figure out how
to add "p's" or "x's"( =COUNTIF(D2:D65,"p") but not
both ("p and/or x").
It was suggested I use the countif.

Suggestions and thanks,


L.


.