Help with formula, pls

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

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

Thanks,
 
What do you want to do when you find them?

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

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
 
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.
 
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.
 
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)
 
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.
 
Back
Top