Less then simple question
 

i'm struggling.

I need to find all the totals in a spreed sheet that are less then 10.00.

Less then simple question
 

KG,

Try the =SUMIF() formula.

That should get you what you need.


"KG" wrote:

i'm struggling.

I need to find all the totals in a spreed sheet that are less then 10.00.

Less then simple question
 

=SUMIF(A1:A100,"<10")


Gord Dibben MS Excel MVP


On Tue, 1 Jul 2008 10:00:01 -0700, KG <KG @discussions.microsoft.com wrote:

i'm struggling.

I need to find all the totals in a spreed sheet that are less then 10.00.

Less then simple question
 

Or if you are just trying to count the number of totals less than 10:

=COUNTIF(A1:A100,"<10")

"KG" wrote:

i'm struggling.

I need to find all the totals in a spreed sheet that are less then 10.00.