Get instant live Excel expert help with SUM Function

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

I need to know if there is a formula to search the document to find the sum from specific cells that occur multiple times.

one of your expert solve this file,,i need the formula which u apply,,, the gray shaded cell i need sum total

I need sum total of each grey shaded rows.

hi, I have a table of numbers 4,3,2 7,9,9 5,3,1 9,8,3 In the first column, 4, 5, and 9 are the highest values in their row. How do I calculate the sum of the max numbers in the column, and also maximum columns in excel? In this case, the sum is 4+5+9.

I have a large pivot table of customers, I need to sum when there are new customers and in reverse, when customers leave. Not sure if this can be done through pivot table. I just can't figure out the best way to do this with a sumif formula

Can you please help me build a sum if fourma to add together the data on tab1 on tab 2. pleasee see example in tab 2 11h

I have a table with transactions. The transactions are by dates, the Month of July, 2016. I need to sum the total for each day and make a new list with just the day totals.

I'm looking to SUM the contents of a range of cells, based on its fonts colour and it's associated 'company'.

Please see attached. I want to sum the cells per Quarter, contents, based on its 'colour' (red or green), and it's 'company' (Resource - Company 1, Resource Company 2 or Resource - vendor). See cell B61 for more context. Thank you