| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF not working w/ cells result of SUM and VLOOKUP
I have a column which I am trying to get the number of occurrances of "9" for
example. The "9" is a formula of two functions 1) VLOOKUP in another column and 2) SUM of various VLOOKUP columns. I can't get COUNTIF to work on either of these columns. I think it doesn't like SUM because it is a result of VLOOKUP columns. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTIF not working w/ cells result of SUM and VLOOKUP
What is (are) your formula(e)?
"VettRacer" wrote: I have a column which I am trying to get the number of occurrances of "9" for example. The "9" is a formula of two functions 1) VLOOKUP in another column and 2) SUM of various VLOOKUP columns. I can't get COUNTIF to work on either of these columns. I think it doesn't like SUM because it is a result of VLOOKUP columns. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTIF not working w/ cells result of SUM and VLOOKUP
=SUM(G51+J51+L51+N51+P51)/5 this is a result of various similar formulas
=VLOOKUP(O51,$V$7:$W$18,2) "Toppers" wrote: What is (are) your formula(e)? "VettRacer" wrote: I have a column which I am trying to get the number of occurrances of "9" for example. The "9" is a formula of two functions 1) VLOOKUP in another column and 2) SUM of various VLOOKUP columns. I can't get COUNTIF to work on either of these columns. I think it doesn't like SUM because it is a result of VLOOKUP columns. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTIF not working w/ cells result of SUM and VLOOKUP
Shouldn't you post the formula that didn't work?
-- Regards, Peo Sjoblom "VettRacer" wrote in message ... =SUM(G51+J51+L51+N51+P51)/5 this is a result of various similar formulas =VLOOKUP(O51,$V$7:$W$18,2) "Toppers" wrote: What is (are) your formula(e)? "VettRacer" wrote: I have a column which I am trying to get the number of occurrances of "9" for example. The "9" is a formula of two functions 1) VLOOKUP in another column and 2) SUM of various VLOOKUP columns. I can't get COUNTIF to work on either of these columns. I think it doesn't like SUM because it is a result of VLOOKUP columns. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTIF not working w/ cells result of SUM and VLOOKUP
=COUNTIF(Q51:Q56,9)
"Peo Sjoblom" wrote: Shouldn't you post the formula that didn't work? -- Regards, Peo Sjoblom "VettRacer" wrote in message ... =SUM(G51+J51+L51+N51+P51)/5 this is a result of various similar formulas =VLOOKUP(O51,$V$7:$W$18,2) "Toppers" wrote: What is (are) your formula(e)? "VettRacer" wrote: I have a column which I am trying to get the number of occurrances of "9" for example. The "9" is a formula of two functions 1) VLOOKUP in another column and 2) SUM of various VLOOKUP columns. I can't get COUNTIF to work on either of these columns. I think it doesn't like SUM because it is a result of VLOOKUP columns. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTIF not working w/ cells result of SUM and VLOOKUP
When you say COUNTIF doesn't work, what results do you get? And your COUNTIF
formula is ..? The fact the a value is derived from a formula shouldn't make any difference? Do you always have valid values in the column(s) you are checking? "VettRacer" wrote: =SUM(G51+J51+L51+N51+P51)/5 this is a result of various similar formulas =VLOOKUP(O51,$V$7:$W$18,2) "Toppers" wrote: What is (are) your formula(e)? "VettRacer" wrote: I have a column which I am trying to get the number of occurrances of "9" for example. The "9" is a formula of two functions 1) VLOOKUP in another column and 2) SUM of various VLOOKUP columns. I can't get COUNTIF to work on either of these columns. I think it doesn't like SUM because it is a result of VLOOKUP columns. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTIF not working w/ cells result of SUM and VLOOKUP
Sorry--here's the formula.
=COUNTIF('OPRS Conv Tracker'!Q51:Q200,9) Which refers to the SUM formula mentioned which that refers to the VLOOKUP. Even when I've changed it so it doesn't reference a another worksheet, it still doesn't work. "Toppers" wrote: When you say COUNTIF doesn't work, what results do you get? And your COUNTIF formula is ..? The fact the a value is derived from a formula shouldn't make any difference? Do you always have valid values in the column(s) you are checking? "VettRacer" wrote: =SUM(G51+J51+L51+N51+P51)/5 this is a result of various similar formulas =VLOOKUP(O51,$V$7:$W$18,2) "Toppers" wrote: What is (are) your formula(e)? "VettRacer" wrote: I have a column which I am trying to get the number of occurrances of "9" for example. The "9" is a formula of two functions 1) VLOOKUP in another column and 2) SUM of various VLOOKUP columns. I can't get COUNTIF to work on either of these columns. I think it doesn't like SUM because it is a result of VLOOKUP columns. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTIF not working w/ cells result of SUM and VLOOKUP
When you say it is not working, do you mean you get an unexpected result or
do you get an error message? -- Regards, Peo Sjoblom "VettRacer" wrote in message ... Sorry--here's the formula. =COUNTIF('OPRS Conv Tracker'!Q51:Q200,9) Which refers to the SUM formula mentioned which that refers to the VLOOKUP. Even when I've changed it so it doesn't reference a another worksheet, it still doesn't work. "Toppers" wrote: When you say COUNTIF doesn't work, what results do you get? And your COUNTIF formula is ..? The fact the a value is derived from a formula shouldn't make any difference? Do you always have valid values in the column(s) you are checking? "VettRacer" wrote: =SUM(G51+J51+L51+N51+P51)/5 this is a result of various similar formulas =VLOOKUP(O51,$V$7:$W$18,2) "Toppers" wrote: What is (are) your formula(e)? "VettRacer" wrote: I have a column which I am trying to get the number of occurrances of "9" for example. The "9" is a formula of two functions 1) VLOOKUP in another column and 2) SUM of various VLOOKUP columns. I can't get COUNTIF to work on either of these columns. I think it doesn't like SUM because it is a result of VLOOKUP columns. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| vlookup shows result one cell above the expected result | Excel Worksheet Functions | |||
| Using sum(1/countif....) not returning expected result | Excel Worksheet Functions | |||
| vlookup based on random result returns incorrect result | Excel Worksheet Functions | |||
| Subtracting a Countif result from a constant | Excel Worksheet Functions | |||
Hybrid Mode
