Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function or lookup??? across a range of cells in a row.
I have data in a row, that I need to find out when any of the cells in that
row equal either 0, or #N/A. I am having trouble experimenting with both the if function, an lookup. my worksheet looks like this for example. Any help would be appreciated A B C 1 0 0 0 1 5 0 0 0 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function or lookup??? across a range of cells in a row.
=COUNTIF(2:2,NA())+COUNTIF(2:2,0)
-- __________________________________ HTH Bob "jwbuyer" wrote in message ... I have data in a row, that I need to find out when any of the cells in that row equal either 0, or #N/A. I am having trouble experimenting with both the if function, an lookup. my worksheet looks like this for example. Any help would be appreciated A B C 1 0 0 0 1 5 0 0 0 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function or lookup??? across a range of cells in a row.
Hi,
You can use the following Array formula: =IF(ISNA(A3:D3),1,SUM(--(A3:D3=0))) To enter an array you must press Shift+Ctrl+Enter rather than Enter. -- If this helps, please click the Yes button Cheers, Shane Devenshire "jwbuyer" wrote: I have data in a row, that I need to find out when any of the cells in that row equal either 0, or #N/A. I am having trouble experimenting with both the if function, an lookup. my worksheet looks like this for example. Any help would be appreciated A B C 1 0 0 0 1 5 0 0 0 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function Range Lookup AGAIN! | Excel Worksheet Functions | |||
Function Range Lookup | Excel Worksheet Functions | |||
return range of data from lookup function | Excel Worksheet Functions | |||
return range of data from lookup function | Excel Worksheet Functions | |||
Limiting the range of a lookup function | Excel Worksheet Functions |