Help with formula, pls
 

Hi,

Is there a way to check for numbers in a range of cells? Ie, to do a kind of
ISNUMBER(A1:A5)?

Thanks,

Help with formula, pls
 

What do you want to do when you find them?

-------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"J.Alex." wrote in message
...
Hi,

Is there a way to check for numbers in a range of cells? Ie, to do a kind
of
ISNUMBER(A1:A5)?

Thanks,

Help with formula, pls
 

One way:

=COUNT(A1:A5)=5

In article ,
J.Alex. wrote:

Hi,

Is there a way to check for numbers in a range of cells? Ie, to do a kind of
ISNUMBER(A1:A5)?

Thanks,

Help with formula, pls
 

I want to display information if the range contains a number (any number). I
have several columns for different dates, and I want to check if customers
(rows) have occurences on any of those dates.

"Ron Coderre" wrote:

What do you want to do when you find them?

-------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"J.Alex." wrote in message
...
Hi,

Is there a way to check for numbers in a range of cells? Ie, to do a kind
of
ISNUMBER(A1:A5)?

Thanks,

Help with formula, pls
 

Maybe

=IF(ROWS(A1:A10)=COUNT(A1:A10),TRUE,FALSE)

Mike

"J.Alex." wrote:

Hi,

Is there a way to check for numbers in a range of cells? Ie, to do a kind of
ISNUMBER(A1:A5)?

Thanks,

Help with formula, pls
 

For example, A1 thru A3:

1
'1
1

So of the three cells, two have true numbers and one has Text

=SUMPRODUCT((A1:A3)*(ISNUMBER(A1:A3)=TRUE))=COUNTA (A1:A3)

will return TRUE if ALL the data in the range are numbers or blanks.
Otherwise FALSE.

--
Gary''s Student - gsnu200745


"J.Alex." wrote:

Hi,

Is there a way to check for numbers in a range of cells? Ie, to do a kind of
ISNUMBER(A1:A5)?

Thanks,

Help with formula, pls
 

So....If you have Customers in Col_A and Dates in Row_1, beginning in B1...

What do you need to do?
Highlight a specific customer if it has a number under a specific date?
Highlight/count/sum customer that have a number under a specific date?
Something different?

--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"J.Alex." wrote in message
...
I want to display information if the range contains a number (any number).
I
have several columns for different dates, and I want to check if customers
(rows) have occurences on any of those dates.

"Ron Coderre" wrote:

What do you want to do when you find them?

-------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"J.Alex." wrote in message
...
Hi,

Is there a way to check for numbers in a range of cells? Ie, to do a
kind
of
ISNUMBER(A1:A5)?

Thanks,

Help with formula, pls
 

Lots of different ways to do it, I see.

Thanks for all the replies!

"J.Alex." wrote:

Hi,

Is there a way to check for numbers in a range of cells? Ie, to do a kind of
ISNUMBER(A1:A5)?

Thanks,

Help with formula, pls
 

You can use =count(a1:a5) to see how many numbers are in that range.

=count(a1:a5)0
would return True if there was at least a single number in that range
it would return false if there were numbers.

=counta(a1:a5)
would count the number of non-empty cells (including formulas that evaluate to
"") in that range.

J.Alex. wrote:

Hi,

Is there a way to check for numbers in a range of cells? Ie, to do a kind of
ISNUMBER(A1:A5)?

Thanks,

--

Dave Peterson