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
|