SUMIF (I Think)...Help on summing a range with different val

[traversd]

Hi,

I have a column of values in A, the values include "POA" , "#N/A", "0", Blank Cells and Cells with Data in.

I want to sum the numeric values in A, ignoring everything else. (I want the total to be displayed at the bottom of COlumn A)

Any Ideas ?

Cheers
Darren

 

[Aladin Akyurek]

On 2002-04-09 09:30, traversd wrote:
Hi,

I have a column of values in A, the values include "POA" , "#N/A", "0", Blank Cells and Cells with Data in.

I want to sum the numeric values in A, ignoring everything else. (I want the total to be displayed at the bottom of COlumn A)

Any Ideas ?

Cheers
Darren

Use:

=SUMIF(A1:A7,"<>#N/A")

where A1:A7 is the target range of interest. Adjust to suit.

 

[traversd]

Thanks,

I had "POA" in there as well, but it seems to have ignored that which i what i wanted.

Thanks
Darren

 

[Aladin Akyurek]

On 2002-04-09 09:40, traversd wrote:
Thanks,

I had "POA" in there as well, but it seems to have ignored that which i what i wanted.

Thanks
Darren

Aggregating functions like SUM, AVERAGE, and SUMIF simply ignore the text values in the range they are fed with.

Aladin