Sum If Range

[rhmkrmi]

Hello

1) How can I do a sumif on one column and get the sum of anything that is a number?

2) How can I do a sumif on one column and get the sum of anything that greater, equal, smaller that zero?

Thanks

 

[Scrappy666]

A Sumif won't sum text values, so only numbers will be be taken into consideration anyway.

=Sumif(A:A,C1,B:B) for example. A is range, B is values, C is criteria

And to take anything larger than 0...

=Sumif(A:A,">"&C1,B:B)