sum formula problems

  1. P

    Index and Match Formula does not sum up...

    http://www.box.net/shared/88vj8y987u Hi. I have an index and match formula on the workbook above, however I need the formula so that it will add up the total value. For Example. On the consignment stock sheet in Y45, it says 5000 as it has match up the value of 92979 on the Stock out sheet...
  2. N

    IF formula

    I use multiple workbooks and each work book contains many worksheets with names of customers which contains their order. I would like to know if it is possible to create formula to calculate a product if any customer should order it. For instance, in the workbook "April", if customer A order...
  3. A

    SUM and Wildcard search

    Hello guys, I'm trying to figure out why this formula isn't working, and hope you can help me. I have a search on a sheet to tell me the number of times two criteria are met in a row, this works fine for exact matches: {=SUM((Data!AM:AM="iPA Workbench error")*(Data!K:K="IT/Software -...
  4. andrewb90

    Help - Adding up a row with weighted results

    Basically I have row #2 with columns b,c,d,e,& f. in each column there are a number of points in the cell. in column g I have the added total of all the points. Is there a way to make, say, column c worth twice as many points as those in column b?
  5. S

    IF Formula, Sum and FALSE

    I am sure the title doesn't help what I am having problems with, but was drawing a blank on what to put. ANYWAY! I am working on an IF Formula to do different things if different cells are True or False. This is what I have so far...

Watch MrExcel Video

This Week's Hot Topics

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
Top