Maybe still a pita but try the pivot table to give you the opens and closed by invoice number, and then use count in the column instead of summing them up.
I've found this forum handy in the past if you are still stumped.
http://www.mrexcel.com/forum/index.php