> How do I count the number of elements in the key "systems" seeing that 
That's the basis of the "muenchian grouping" technique:
count(/inventory/row/serial[generate-id()=generate-id(key('systems',.))])

David