Try...

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

Hope this helps!

In article
<leigh.robinson.26hpsm_1145414401.5477@excelforu m-nospam.com,
leigh.robinson
<leigh.robinson.26hpsm_1145414401.5477@excelforu m-nospam.com 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