Thread
:
Question using countif
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_]
external usenet poster
Posts: 1,766
Question using countif
Hi,
Actually the simplest approach would be to use text to columns to segregate
numbers in different columns and then use the countif
=countif(A3:F50,A55)
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Tim JA" <Tim
wrote in message
...
I'm using office 2007, specifically excel. I cannot get the countif
function
to accurately count cells containing multiple numbers. For example below
is a
column containing both single and multiple numbers. I'm trying to get a
count
based on any number in the column. Perhaps, I'm using the wrong count
function. I've tried using wild cards... but to no avail. Your help would
be
greatly appreciated.
5
9
2,6
2
3,6
6,7
5,13
2
6
1,10,13
13
Reply With Quote
Ashish Mathur[_2_]
View Public Profile
Find all posts by Ashish Mathur[_2_]