3 criteria

  1. T

    Combobox value loop column lookup and return all matching results to a sheet

    I have a little trouble with this one. I have three combo box that I required the value of each box to lookup the data in Sheet 1 Column E, F, G and when a match is found return row number so that all data in Column H, I, j, k, L are placed to Sheet 2 in the next available empty row. However...
  2. T

    Summing a column using multiple criteria

    I have 4 columns, Total Client Year Category I am wanting to add up the totals for each client IN 2014 with a certain CATEGORY When I use SUMIFS, it only allows me to insert 2 criteria. How can I calculate totals using the 3criteria I need? Thanks!
  3. S

    matching 3 criterias to return a sum

    Hi, I'm really struggling to match 3 criterias and return the cell data in B4:G6. It seems to work when I'm not search more than one cell but as soon as I want to search a criteria over several cells i.e. B2:G2=A3 it returns N/A but if the serach is simply B2=A3 then it returns...
  4. M

    Countif within a range

    I am trying to figure out how to do a countif within a range with 1 addition criteria. I have miles from our facility to our customers. I have already used the following formula to get the total number of trips to the customers within a mileage range for the first 2 months of the year...

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