sumproduct ; wildcards ;

  1. Jovinchious

    VLOOKUP challenge

    Hello everyone, I need a bit of help. I need some formula that will make me the following… if the text in the A column of "sheet1" is the same as the text anywhere in the A column of "sheet2", and also if the text in the B column of "sheet1" is the same as the text anywhere in the B column of...
  2. FuzzyTom

    The same as Wildcard replacement when using Sumproduct

    I found this answer to a query similar to mine, Wildcard replacement when using SUMPRODUCT I have a little different situation ... namely I am looking to find out how to apply this solution in VBA: I have a variable ClName which is assigned to the tab name and I would like to check if this tab...
  3. B

    SUMPRODUCT Advice Please

    Hi, I have a table of People/Roles, how much each costs per month, and what proportion of their time that person will spend in the Role each month (1 = 100%, 0.5 = 50% etc). <tbody> Department Name Role Monthly Cost Jan-15 Feb-15 Mar-15 Apr-15 May-15 IT John Analyst £60 1.00...
  4. T

    SUMPRODUCT Question!

    Hi, I am having problems with a SUMPRODUCT formula and have searched high and low for a solution with very little success! Hopefuilly someone here can help! I have three columns and am trying to calculate the total of the third where the first two columns meet certain criteria. The following...

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