Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula returns error; abbreviating the formula | Excel Discussion (Misc queries) | |||
Formula Error-Error Message | Excel Programming | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
How do I replace "#N/A" error, to continue my formula w/o error? | Excel Worksheet Functions | |||
Formula error with Mac resulting in '#NAME' error | Excel Programming |