dish

  1. I

    Sumifs?? Left?? Dish sales

    I'd like to sum all of the dish sales based on the Location number and Product IDs. Can I do this without creating a helper column? <colgroup><col><col><col span="2"><col></colgroup><tbody> A B C D 1 Location Product ID Product Desc Sales 2 555652 Houston 10047108 Dish 12" 4 3 555652...
  2. B

    Recipe Inventory Control

    Hi Please excuse me if this topic has arisen before. I did do a search but did not see anything to assist me so far. I have a small restaurant and retail gift shop under the same roof. Keeping accurate inventory/stock control of the retail side is fairly straight forward even though at present...
  3. R

    conditional pop up message

    I have a file and am looking in column E and G. If Column E="Bob's" and column G="1234", I'd like a message to pop up stating "abc". How do I write this. I have the code below, but that only looks at individual columns. Sub Bob's() If Range("E3:E30").Value = "Bob's" Then MsgBox "If this Bob's...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top