Sumif Command
 

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
------------------------------------------------------------------------
leigh.robinson's Profile: http://www.excelforum.com/member.php...o&userid=33628
View this thread: http://www.excelforum.com/showthread...hreadid=533991

Sumif Command
 

Does this helps.

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


--
vane0326
------------------------------------------------------------------------
vane0326's Profile: http://www.excelforum.com/member.php...o&userid=14731
View this thread: http://www.excelforum.com/showthread...hreadid=533991

Sumif Command
 

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

Sumif Command
 

I tried it and it still doesn't work, I think the problem is with the
"=B1" part.
Thanks for your help


--
leigh.robinson
------------------------------------------------------------------------
leigh.robinson's Profile: http://www.excelforum.com/member.php...o&userid=33628
View this thread: http://www.excelforum.com/showthread...hreadid=533991

Sumif Command
 

Perfect, thanks for the help guys


--
leigh.robinson
------------------------------------------------------------------------
leigh.robinson's Profile: http://www.excelforum.com/member.php...o&userid=33628
View this thread: http://www.excelforum.com/showthread...hreadid=533991