P
Paul R
I would to find out how I can lookup a column and count the number of times
a preticular number appears innthat column.
Thanks
Paul
a preticular number appears innthat column.
Thanks
Paul
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Ken Wright
=COUNTIF(A:A,1)
will count the times the number 1 appears in Col A
will count the times the number 1 appears in Col A
D
Dave R.
Countif works if you want to count the # of "1" in a range that contains
1,11,111 and return the value 1.
if not, you want to count times that a character (number) occured, look for
the recent message in this group called "counting text" started by "stavrou"
which contains a formula to count all occurences.
1,11,111 and return the value 1.
if not, you want to count times that a character (number) occured, look for
the recent message in this group called "counting text" started by "stavrou"
which contains a formula to count all occurences.
S
Scott S.
Paul,
Use the COUNTIF function
=COUNTIF(A1:A100,1)
where
A1:A100 is the range of numbers
and
1 is the particular number you are trying to count.
Regards,
Scott
Use the COUNTIF function
=COUNTIF(A1:A100,1)
where
A1:A100 is the range of numbers
and
1 is the particular number you are trying to count.
Regards,
Scott
C
Comic
Hey Paul R?
Are you Pee Pee Herman?
Are you Pee Pee Herman?