Get instant live Excel expert help with SUM Function

spreadsheet which I am looking to get modified. I use it for Fx trading and looking at returns of each currency pair.. I am looking to add on extra sheets With the same formula and on the pitot table I’m looking to add on extra columns which are the sum of profits and above it will be sheet 1, 2 and 3. So basically the pivot table stays much the same except there will be and extra columns for sum of profits for each sheet. I may have up to a total of 30 sheets open so will need 30no columns with sum of profits. Also when I adjust the numbers in the report it doesn’t adjust the figures in the pivot table.

I need to sum amounts using sumifs for a range of days

I need to say whether the sum of a column if equal or over $2000

I need to sum a cell, only if another cell is another colour

Can I use an if statement in data validation . for example in Cell A1 I have a total percentage sum formula l that will be between 1 and 100. somehow I want to data validate the cell so that if the sum is over 100% an error is given. Can that be done

I need a formula to do excel find highest value in column H while making sure their respective sum of column A is under 60,000.

I need a formula to sum the total number of hours worked within a date range, separating hours worked on sundays and local holidays, and hours worked on regular workdays.

I need to set a formula that can sum two or more same value.

correct function used in cell A3 to calculate the sum of values in NumAttedig column

I am needing some help with a formula to sum data numbers across multiple entries. I have played with the sumif formula, and it does what i need, but only with one column of "range". I am needing to do this across 22 columns of "range". I have an example of what I am trying to do to show.