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.
.
|