Subtotal to ignore #N/A

[krishna334]

Hi All,

I am trying to find the sum of a range (C6:C30) which has some #N/A cells, i would like the subtotal to exclude the #N/A cells and give the sum of the rest of the cells.
I entered the below formula:

=SUBTOTAL(9,(IF(ISNA(C6:C30),"",(C6:C30)))) but this itself gives #N/A

Can you give me the correct formula.

 

[Robert Mika]

Hi All,

I am trying to find the sum of a range (C6:C30) which has some #N/A cells, i would like the subtotal to exclude the #N/A cells and give the sum of the rest of the cells.
I entered the below formula:

=SUBTOTAL(9,(IF(ISNA(C6:C30),"",(C6:C30)))) but this itself gives #N/A

Can you give me the correct formula.

Which version of Excel are you using?

 

[krishna334]

Sorry to reply late...i am using 2007 version

 

[Robert Mika]

Sorry to reply late...i am using 2007 version

Excel Workbook
	C	D	E
1	Stan		4
2	2
4	#N/A
8	2
9	#N/A
Sheet1