Hi Brian, many thanks for replying.
I have two columns of financials but within those column, some rows are blank. Eg:
Jan 06 Jan 07
12000 12222
33099
77000
78900 89000
I am using =(D136-P136)/ABS(P136) to establish the percentage change between January 2006 and January 2007. Naturally if either column has rows without any figure I get the Div/X error, which messes up the spreadsheet.
Cheers
C
Hi
You can use the ISERROR Function to test for an error:
=IF(ISERROR((D136-P136)/ABS(P136)),"",(D136-P136)/ABS(P136))
So if there is an error in the calculttion it will return nothing as per the "" or do the calculation if there is no error.
Hope this helps
Naturally if either column has rows without any figure I get the Div/X error, which messes up the spreadsheet.
...
Aladin:
I don't believe you can use non-contiguous ranges with COUNTBLANK