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