| 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. |
| 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 | |||
Threaded Mode
