altering formula

  • Thread starter Thread starter RDL
  • Start date Start date
R

RDL

Hi,

I am hoping someone can help me with changing a formula

I have a large column where some cells contain an "X".
I've had to replace the X with certain dates. The formula
I have to sum the # of X's is: =COUNTIF(R3:R373,"x")&"
applicants". This tells me how many applicants have found
a doctor. Now I need to know the date they found a
doctor, so I replaced the X with the date, but I still
need to know how many applicants. Is there a way to sum
the cells that have a date in them with a similar formula?

Thanks in advance. ( I'm having a hard time thinking today)
 
Try This:

=COUNTIF(R3:R373,">0")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Hi,

I am hoping someone can help me with changing a formula

I have a large column where some cells contain an "X".
I've had to replace the X with certain dates. The formula
I have to sum the # of X's is: =COUNTIF(R3:R373,"x")&"
applicants". This tells me how many applicants have found
a doctor. Now I need to know the date they found a
doctor, so I replaced the X with the date, but I still
need to know how many applicants. Is there a way to sum
the cells that have a date in them with a similar formula?

Thanks in advance. ( I'm having a hard time thinking today)
 
Frank,

I'm not sure what is meant by the formula you suggested.
A shortened version of my column would look like this:

Date found
Doctor
John
Jay
Jane X
Bob
Burt X
Barb X

3 applicants

where cell R374 sums up the number of X's. Only now, the
X's are being replaced with actual dates in Column R, such
as 08/09/03, which is the date, say, that Jane Doe found a
doctor. Only I still need to sum up the number of cells
that have dates in them to tell me how many applicants
have found doctors.(Basically I have to switch it to an
actual date because I need it for another formula later,
otherwise the X's would have been fine)

I hope I explained it better.

Thanks, Rebecca
 
(sorry, I meant to post this as a reply)
Hi guys,
I am hoping you can help me with one more thin for this
formula. Part of my spreadsheet looks like this:

COLUMN C COLUMN R COLUMN S
Date of Date Found Wait in
Application Doctor Months

06/30/03 11/20/03 4

06/30/03 11/20/03 4


06/30/03 11/20/03 4

08/01/03 04/19/04 8
08/01/03 04/19/04 8


Before, I was asking you about column R. The cells that
contain a number in column S have the formula
=DATEDIF(C6,R6,"m")

I need to use that formula for the whole column, so that
when a date is entered in column R, the difference in
months automatically appears in column S. The cells with
numbers in Column S already do that, but I need the whole
column to do that when dates are entered later on, when
aplicants find a doctor. What I need is something added
onto the formula, =DATEDIF(C6,R6,"m") that takes into
account blank cells, so the error #NUM! doesn't appear,
the cell remains blank even though the formula is there.
I tried adding ,">0" to the end but that didnt work.

Do you understand what I mean??

..
 
One way:

=IF(C6*R6>0,DATEDIF(C6,R6,"m"),"")

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


(sorry, I meant to post this as a reply)
Hi guys,
I am hoping you can help me with one more thin for this
formula. Part of my spreadsheet looks like this:

COLUMN C COLUMN R COLUMN S
Date of Date Found Wait in
Application Doctor Months

06/30/03 11/20/03 4

06/30/03 11/20/03 4


06/30/03 11/20/03 4

08/01/03 04/19/04 8
08/01/03 04/19/04 8


Before, I was asking you about column R. The cells that
contain a number in column S have the formula
=DATEDIF(C6,R6,"m")

I need to use that formula for the whole column, so that
when a date is entered in column R, the difference in
months automatically appears in column S. The cells with
numbers in Column S already do that, but I need the whole
column to do that when dates are entered later on, when
aplicants find a doctor. What I need is something added
onto the formula, =DATEDIF(C6,R6,"m") that takes into
account blank cells, so the error #NUM! doesn't appear,
the cell remains blank even though the formula is there.
I tried adding ,">0" to the end but that didnt work.

Do you understand what I mean??

..
 
Back
Top