VBA assistance with Sumifs with Table Ranges

[Sintek]

Hi All

I have attached a sample file. My below code populates my UserForm with total of all sales. How can I amend to add another argument i.e. ComboBox1 which is Waiter Name to Populate my textBoxes.

Please Login or Register  to view this content.

[Sintek]

I just can't get this right

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

You appear to have some date picker Reference object in your VBE which of course I don't have hence can't use your code. However in principle just add another SUMIFS argument. So untested but presumably

Please Login or Register  to view this content.

.

similarly for the other text boxes

[xlnitwit]

Hi,

You missed a Range call

Please Login or Register  to view this content.

[Sintek]

Wow.....Really

Please Login or Register  to view this content.

[Sintek]

Thanks xlnitwit

[Sintek]

Thanks Richard

I came right

[Richard Buttrey]

Hi,

You missed a Range call

...Indeed. Thanks for the catch.

For completion

Please Login or Register  to view this content.