Less then simple question

[KG]

i'm struggling.

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

 

[Huber57]

KG,

Try the =SUMIF() formula.

That should get you what you need.

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP

 

[Huber57]

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

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