feb-17

  1. T

    Formula to sumif a column and all corresponding values in a table, if it matches a condition/s in another table

    <tbody> Table 1 Metric1 (Unique) Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 A B C D E F Table 2 Metric1 Month Metric2 A Jan-17 166 A Apr-17...
  2. C

    Countif multiple criteria

    HI, Need help again. In Cell A1, I have data validation list - Jan 17, Feb 17, Mar 17 & so on In B1, I have list of members like A, B, C, D In Sheet2, I have raw data contains A Jan-17 B Jan-17 A Feb-17 C Feb-17 A Feb-17 B Mar-17 What if I change month in data validation then it should...
  3. Y

    Sum with Multilple Criterias at Row & Column

    Hi, I need help on the below issue. Other than SUMPRODUCT, what are the other formulas can be used? Appreciate your kind helping hand Thank you!! <tbody> Apple Apple Apple Orange Orange Orange Jan-17 Feb-17 Mar-17 Jan-17 Feb-17 Mar-17 1 Sales Volume...

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