sum formula problems

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...

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...

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 -...

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?

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...