| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Values amongst #N/As
I have a column of Vlookups, I need to know how many are returning a value
and how many are returning #NAs, what formulas do I use to do this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting Values amongst #N/As
=COUNTIF(K:K,"#N/A")
-- __________________________________ HTH Bob "Paul W Smith" wrote in message ... I have a column of Vlookups, I need to know how many are returning a value and how many are returning #NAs, what formulas do I use to do this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting Values amongst #N/As
=Countif(A1:A100,"#N/A") to count #N/A and =Countif(A1:A100,"<#N/A") to count values other than "#N/A" -- NBVC Where there is a will there are many ways. 'The Code Cage' (http;//www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113005 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting Values amongst #N/As
or even
=COUNTIF(K:K,NA()) -- __________________________________ HTH Bob "Paul W Smith" wrote in message ... I have a column of Vlookups, I need to know how many are returning a value and how many are returning #NAs, what formulas do I use to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting values in one cell based on values in another | Excel Discussion (Misc queries) | |||
| Counting Values | Excel Worksheet Functions | |||
| Counting only values | Excel Worksheet Functions | |||
| counting rows with same values for multiple values | New Users to Excel | |||
| Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Linear Mode
