Sumif Command

[leigh.robinson]

I am trying to this but it doesn't return any values, can someone help
=SUMIF(A19:A10000,">=B1")
i.e sum all the values that are greater than the number I have in B1.
Any help would be appreciated
Cheers

[vane0326]

Does this helps.

=SUMIF(A19:A10000,">=B1",B19:B10000)

[Domenic]

Try...

=SUMIF(A19:A10000,">="&B1)

Hope this helps!

In article
<[email protected]>,
leigh.robinson
<[email protected]> wrote:

> I am trying to this but it doesn't return any values, can someone help
> =SUMIF(A19:A10000,">=B1")
> i.e sum all the values that are greater than the number I have in B1.
> Any help would be appreciated
> Cheers

[leigh.robinson]

Perfect, thanks for the help guys