Get instant live Excel expert help with SUM Function

I need a formula that can provide me with the sum of two cells. In a few of the cells there is an "-" that equals 0. Please give me formula that show "-" equals 0.

I would like to enter a text into a field which will represent a certain value. The value is determined by the characters of the text. Each character corresponds to a specific number. The value should be the sum of the corresponding numbers. Thanks

i have two sheets A and B i would like to have sum of the amounts for 3 days and 2 days ago in sheet B in column B for example: in sheet B for date 7/6/17, to be read the amount from date 7/3/17 and 7/2/17 and added these as a result

I have a stat spreadsheet that inputs "Yes" "No" or "other information" (Information changes) in two matched up Columns for multiple Rows of different stats based on the one of twelve options I can pick in a drop down list on the top of the said columns. i pick one of the twelve options and my stat list changes per choice. If a stat(stats labeled in Column A) in the column B says "Yes", the stat for that Row gets added to a sum of every other stat that says "Yes" in Column B. If it says anything else, according to my current formula that stat wont be added to the Sum. Sum formula: =IF(B7="Yes",+250,0)+IF(B8="Yes",+300,0)..........etc x16 This works great, but here's the problem, the two columns coincide. If Column B says "No" or "Ever changing answer" BUT Column C says "Yes" I need that Sum formula to add the stat. I tried this formula with no success: =IF(B7:C7="Yes",+250,0)+IF(B8:C8="Yes",+300,0)..........etc I also need a formula that wont add each stat Row twice if both Column B and Column C's inputs come out "Yes"

I need a VBA/Macros script and/or formula. I have a column of cells. Each cell contains a combination of text, numbers, and currency amounts ($). Some cells have only one currency amount while others have up to 6 different currency amounts. All cells contains some combination of currency amounts plus miscellaneous text and numbers. I need to create a 2nd column that SUM all the currency amounts in each cell, while ignoring all the rest of the text and numbers in each cell. I have uploaded a file with several example sells. I've worked with two great experts already on this problem and both have been very helpful.

I am entering sales figures for staff and have filters, when I choose a particular filter how do I create a sum to add up the figures

Do you know how to set ranges in excel? For example: =IF(a1=a2=a3, sum(b1:b3),0)? It could be a1-a3 or it could be through a5 or further. I can't seem too define the range based on like values

i have mulitple Data(total of mileage done) and type(province/state) i want the sum of the total mileage in all prov/state

I am trying to create a formula that will search for a word in column G, then also search for a word in column H, then if it finds both words then return the sum of column N in cell D1028. ie if column G = Jul 2017, and column H = Sent, and column N = 1, then D1028 would be the result of summing column N for rows that returned a yes for all queries. Any help would be greatly appreciated! :) Thanks Nic

Hi I am looking for your help with formula in finding out the similar opposite values in a big data sheet. I have attached the sample worksheet where row no. 2 and 5 have similar opposite value as well as row no. 2 and 10 have similar values. I want to find out either row 2 and 5 or 5 and 10 so that the sum of 2 items found is 0