Thread: countif??
View Single Post
  #5   Report Post  
L/P
 
Posts: n/a
Default


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.


.