Forum Discussion
Summing positive/negative amounts across sheets
Message Edited. Sorry for my mistakes in the original. ---------------------------------------------------------------- Sum Profit and/or Loss from a column from 1 sheet (Raw) in 2nd sheet (Stats)...
Good Morning Sergei.
Profit.S is Defined Name for the start of Profit column. i.e. Column W, row 2, or $W$2 in my sheet "Orders". Profit.E is highest row in same column. It increases as I insert new rows into the "Orders" sheet using "Insert copied cells", currently, in my up to date spreadsheet it is W10855. Row 1 is most recent data and row 10855 is oldest data. Just an FYI, this spreadsheet is a record of my FOREX Trading going back to October 2021. Hope that I am making sense to you, please tell me if I need to explain more or better.
If in first file we have
when in another file
formula
=SUMPRODUCT(
'Funded Bootcamp.xlsm'!Profit.S:'Funded Bootcamp.xlsm'!Profit.E *
('Funded Bootcamp.xlsm'!Profit.S:'Funded Bootcamp.xlsm'!Profit.E>0))works. Perhaps the same for other formulae.