Formula Error
 

=COUNTIF($X$35:$X$2000,AC15),($Y$35:$Y$2000,AC15), ($Z$35:$Z$2000,AC15),($AA$35:$AA$2000,AC15)

WHAT i AM TRYING TO DO IS...LOOK IN ALL FOUR COLUMNS X,Y,Z,AA
BETWEEN ROW 35 AND 2000, LOOK FOR A DATA # THAT CORRESPONDS WITH AC15..AND
ADD THEM

Formula Error
 

I DO NOT WANT TO ADD UP THE NUMBERS..i WANT TO ADD HOW MANY TIMES IT HAS SEEN
THAT NUMBER

"Ken G" wrote:

=COUNTIF($X$35:$X$2000,AC15),($Y$35:$Y$2000,AC15), ($Z$35:$Z$2000,AC15),($AA$35:$AA$2000,AC15)

WHAT i AM TRYING TO DO IS...LOOK IN ALL FOUR COLUMNS X,Y,Z,AA
BETWEEN ROW 35 AND 2000, LOOK FOR A DATA # THAT CORRESPONDS WITH AC15..AND
ADD THEM

Formula Error
 

Please do NOT shout (type in all caps). Have you tried
=COUNTIF($X$35:$aa$2000,AC15)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ken G" wrote in message
...
I DO NOT WANT TO ADD UP THE NUMBERS..i WANT TO ADD HOW MANY TIMES IT HAS
SEEN
THAT NUMBER

"Ken G" wrote:

=COUNTIF($X$35:$X$2000,AC15),($Y$35:$Y$2000,AC15), ($Z$35:$Z$2000,AC15),($AA$35:$AA$2000,AC15)

WHAT i AM TRYING TO DO IS...LOOK IN ALL FOUR COLUMNS X,Y,Z,AA
BETWEEN ROW 35 AND 2000, LOOK FOR A DATA # THAT CORRESPONDS WITH
AC15..AND
ADD THEM

Formula Error
 

Try

=COUNTIF($X$35:$AA$2000,AC15)

Hope this helps,

Hutch

"Ken G" wrote:

I DO NOT WANT TO ADD UP THE NUMBERS..i WANT TO ADD HOW MANY TIMES IT HAS SEEN
THAT NUMBER

"Ken G" wrote:

=COUNTIF($X$35:$X$2000,AC15),($Y$35:$Y$2000,AC15), ($Z$35:$Z$2000,AC15),($AA$35:$AA$2000,AC15)

WHAT i AM TRYING TO DO IS...LOOK IN ALL FOUR COLUMNS X,Y,Z,AA
BETWEEN ROW 35 AND 2000, LOOK FOR A DATA # THAT CORRESPONDS WITH AC15..AND
ADD THEM

Formula Error
 

Shoot ..that was simple..thanks for your help
"Tom Hutchins" wrote:

Try

=COUNTIF($X$35:$AA$2000,AC15)

Hope this helps,

Hutch

"Ken G" wrote:

I DO NOT WANT TO ADD UP THE NUMBERS..i WANT TO ADD HOW MANY TIMES IT HAS SEEN
THAT NUMBER

"Ken G" wrote:

=COUNTIF($X$35:$X$2000,AC15),($Y$35:$Y$2000,AC15), ($Z$35:$Z$2000,AC15),($AA$35:$AA$2000,AC15)

WHAT i AM TRYING TO DO IS...LOOK IN ALL FOUR COLUMNS X,Y,Z,AA
BETWEEN ROW 35 AND 2000, LOOK FOR A DATA # THAT CORRESPONDS WITH AC15..AND
ADD THEM

Formula Error
 

Thanks Don, sorry bout the shouting..

"Don Guillett" wrote:

Please do NOT shout (type in all caps). Have you tried
=COUNTIF($X$35:$aa$2000,AC15)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ken G" wrote in message
...
I DO NOT WANT TO ADD UP THE NUMBERS..i WANT TO ADD HOW MANY TIMES IT HAS
SEEN
THAT NUMBER

"Ken G" wrote:

=COUNTIF($X$35:$X$2000,AC15),($Y$35:$Y$2000,AC15), ($Z$35:$Z$2000,AC15),($AA$35:$AA$2000,AC15)

WHAT i AM TRYING TO DO IS...LOOK IN ALL FOUR COLUMNS X,Y,Z,AA
BETWEEN ROW 35 AND 2000, LOOK FOR A DATA # THAT CORRESPONDS WITH
AC15..AND
ADD THEM

Formula Error
 

Thanks Tom...Duh!! just needed to think though it of what I want to look at
thanks again

"Tom Hutchins" wrote:

Try

=COUNTIF($X$35:$AA$2000,AC15)

Hope this helps,

Hutch

"Ken G" wrote:

I DO NOT WANT TO ADD UP THE NUMBERS..i WANT TO ADD HOW MANY TIMES IT HAS SEEN
THAT NUMBER

"Ken G" wrote:

=COUNTIF($X$35:$X$2000,AC15),($Y$35:$Y$2000,AC15), ($Z$35:$Z$2000,AC15),($AA$35:$AA$2000,AC15)

WHAT i AM TRYING TO DO IS...LOOK IN ALL FOUR COLUMNS X,Y,Z,AA
BETWEEN ROW 35 AND 2000, LOOK FOR A DATA # THAT CORRESPONDS WITH AC15..AND
ADD THEM