Countif to show totals in userform

[sniper1]

Hi everyone!

I have a simple user form that I like two textboxes to show totals of each criteria (under the header status: In and out).


Userform controls

txtIn for a total of all tools in (from column c)
txtOut for a total of all tools out(from column c)


I have attached 3 screenshots of sheet, code, and userform. What I have so far is not working, I am not able to get this to work. Am I missing something here? Thank you all!!!

[mikerickson]

Your CountIf formula is wrong. But its not clear what you want to count.

All entries "In". If so the line should be

Please Login or Register  to view this content.

All entries "In" and Deptartment "A". If so,

Please Login or Register  to view this content.

Note the function CountIfs

This will put the value in your myResult variable.

[sniper1]

mikerickson,

I made the correction, but I am not seeing the totals in the userform. I think I am doing this backward. In the txtIn, I have this: Private Sub txtIN_Change()
Call AddIn
End Sub

Thank you!

[mikerickson]

The userform you showed has two text boxes for the result, but no way for the user to specify what department's information they want to see.
(You still haven't clarified if you want to count all IN values or only the IN values from one department).

[sniper1]

Thank you, sir, got it fixed now! Thank you!!