Daniel

=SUMIF(B:B,"<",A:A)

Regards

Trevor


"Daniel" wrote in message
...
How do I return a sum of a range of cells corresponding to a certain
criteria

(For example: I want the sum of all cells in A column which have a value
in
B colomn:

A B
1 A
3 B
6

- I only want the sum of cells a1, a2 = 4)

Thanks.