Summing ISNumber statements

[agnerc]

I have a column with an ISNUMBER formula. The forumla reads =IF(ISNUMBER(D42),"1","0"), this is reading from a date cell. If there is a date in the cell, the result will be a number 1. I am doing this for many rows.

I want to sum up the number of 1's but when I use the SUM formula, I am not getting any result, my sum remains at 0.

Any suggestions?

Thank you,

Chris

 

[Marcelo Branco]

Welcome to Mr Excel forum

Your formula is returning a string "1", not a number.
Try without the quotes
=IF(ISNUMBER(D42),1,0)

M.

 

[footoo]

You can get the total number of cells in column D containing numbers with, for example :

=COUNT(D1:D10)

or

=COUNT(D:D)

 

[agnerc]

Thank you Marcelo.

Another problem I am having.

I have 3 cells: (A1) Feb-10-Mon (A2) Feb-25-Tue (A3) 15

What I would like to do is subtract the dates and if the days are equal to or less than A3 then return a 1, if not then return a 0.

Thank you,

 

[jtakw]

Thank you Marcelo.

Another problem I am having.

I have 3 cells: (A1) Feb-10-Mon (A2) Feb-25-Tue (A3) 15

What I would like to do is subtract the dates and if the days are equal to or less than A3 then return a 1, if not then return a 0.

Thank you,

Hi,

If those are True Date Values in Column A.

C1 formula is Not inclusive of Start or End Date.
C2 formula is Inclusive of Start of End Date.

Book1
	A	B	C	D
1	Feb-10-Mon		1	Not inclusive
2	Feb-25-Tue		0	Inclusive
3	15
Sheet93

Cell Formulas
Range	Formula
C1	=--(A2-A1<=A3)
C2	=--(A2-A1+1<=A3)