IF Statements-column of values which are random

Hello,
a)If I have a column of values which are random, and I only wish to sum eg. items that are <200 how can I do this, IN ONE GO?

I am trying to do this but am obviously failing.
Can someone advise.

Thanks in advance.

G

Hi

Assuming your data is in Column A starting at A1 to A100, write the following formula in Cell A101 for the result:

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

This will sum only the numbers which are smaller than 200.

Teylyn