On 31 May, 09:59, royUK wrote:
Is Range("home") the criteria for the SUMIF?

--
royUK

Hope that helps, RoyUK
For tips & examples visit my 'web site' (http://www.excel-it.com/)
------------------------------------------------------------------------
royUK's Profile:http://www.thecodecage.com/forumz/member.php?userid=15
View this thread:http://www.thecodecage.com/forumz/sh...d.php?t=102011

thanks for replying. Yes it is.
Robert