Remember Me?

#1
February 24th 09, 03:48 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Dec 2008 Posts: 12
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
February 24th 09, 04:17 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jun 2008 Posts: 2,420
if function or lookup??? across a range of cells in a row.

=COUNTIF(2:2,NA())+COUNTIF(2:2,0)

--
__________________________________
HTH

Bob

...
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
February 24th 09, 05:41 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Nov 2008 Posts: 3,346
if function or lookup??? across a range of cells in a row.

Hi,

You can use the following Array formula:

=IF(ISNA(A33),1,SUM(--(A33=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

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post robert Excel Worksheet Functions 3 January 23rd 09 10:40 PM robert Excel Worksheet Functions 2 January 23rd 09 09:33 PM Boom1 Excel Worksheet Functions 0 August 18th 06 05:13 PM Boom1 Excel Worksheet Functions 0 August 18th 06 05:13 PM Dorn Excel Worksheet Functions 5 November 8th 05 01:59 AM

All times are GMT +1. The time now is 11:30 PM.