mutliple criteria

  1. L

    Matching customer emails from 2 different sheets to get a count

    Hiya all, I'm struggling a bit with I have a list of customers who bought Product A (which is a sample of the main product) on one sheet, then I have a list of customers who bought Product B (which is the main product) on another sheet. Is there a way that I can (on a separate summary sheet)...
  2. M

    Criteria-based Calculation of the Average Amount of Working Hours

    Hey everyone, I'm struggling with trying to correct a formula which is currently delivering a wrong result or at least not the result I am supposed to achieve. The problem is that the current formula divides by the number of all rows / bookings with the same "contract number" on sheet1...
  3. R

    VBA Counting instances of journeys

    Hi I need to use VBA to count how many times a journey occurs in each Quarter. I have a table which shows the Journeys to be counted (in either direction) D:E, along with the various journeys per Quarter in column A. So in the example below. the journey London to Cardiff (either direction)...

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
Back
Top