SumIf Function Help

[seenfresh]

I would like to sum a range if the cell contents are number values, hence I have #N/A in the range and would like to be able to sum this range.

for example my range is M3:M105 and I want to just sum the number values not text

Any help would be great!

Thanks in advance,

 

[Aladin Akyurek]

I would like to sum a range if the cell contents are number values, hence I have #N/A in the range and would like to be able to sum this range.

for example my range is M3:M105 and I want to just sum the number values not text

Any help would be great!

Thanks in advance,

=SUM(SUMIF(M3:M105,{"<0",">0"}))

 

[seenfresh]

Thanks Aladin,

You never fail!

As soon as I saw this I thought **** I should have thought of this!

base my sum on the sumif, which would disregard the false values of #N/A or text values!

How does {} fall into proper formatting does this help identify the comma into just one argument instead of excell seeing it as the False argument criteria!

Very nice

Thanks again!

Sean