#excelproblem

  1. M

    How to apply if and sumifs function in this case

    Hello, I need to combine if and sumifs function for this case that i have. (according to my lecture) The case is : to fill product cost column (Sheet 1) , they asked me to put the sum of unit price ( in Sheet 2) if the product type (Sheet 1) is Manufactured. If the product type is Bought-in...
  2. T

    delete rows which subtotal value is 0

    Hi, Right now, i'm trying to develop an excel dashboard to show the sales achievement of several stores every month, In this case, i need to sum the rows that have the same month & remove the entire row that have 0 result in total row, Because of the next user of my dashboard isn't me, I need to...
  3. T

    How to sum multiple columns using index & match

    Hi... I hope someone could show me the right direction here... So, here is my table : A B C D E F G H I J K L M <tbody> ID STORE MILK BREAD MILK ORANGE COFFEE TEA...

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