countif?

1st....

So I am trying to count the total diskspace used for each virtual machine

dont you mean SUM?

2nd Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

What is your expected results, for example, HD1.5TB_13?

Try

Formula:

Please Login or Register  to view this content.

How do you arrive at that?

I read Quang's question, the instructions in the upload and then did the math backwards. It seemed to work. So I guessed after that.

FT, my question was to the OP lol, you and I posted at about the same time

Oh.____________________________

Originally Posted by matty0511

So whats the conclusion?

Does solution from FT in #8 meet requirement?

Did you try my formula in post #8?

I believe it does what you want. Enter it in C52. The table auto fills.

	B	C	D
50	DATASTORE FREE SPACE
51	DATASTORES	FREESPACE
52	HD1.5TB_13	1165	Capacity minus the sum of all space used on HD1.5_13
53	HD1.5TB-13_2	1360	Capacity minus the sum of all space used on HD1.5_13-2
54	HD3TB_13	2730	Capacity minus the sum of all space used on HD3TB_13
55	SSD240_13	178.75	Capacity minus the sum of all space used on SSD240_13

I just now copied from the post #8 function code window and pasted into your latest upload. It works fine at my end.

If you select any of the cells in the table beneath the title 'Datastore Capacity' you'll see a new tab above the ribbon that says 'Table Tools'. Select that tab and look at the left end of the ribbon and you'll see the table name (table 2) displayed.
A good way to see what the formula in C52 is doing is to select that cell then select and run through the 'Evaluate Formula' on the 'Formulas' tab.
Let us know if you have any questions.