countifhelp.PNG

I am trying to keep track of remaining space on each of my Datastores on each of my VMware Hosts. Ive create a spreadsheet with each datastore capacity.(on the left side of the image) I have also documented each virtual machines hard drive, location and size.(on the left side of the image).

So I am trying to count the total diskspace used for each virtual machine based on the location (datastore) minus the capacity.