Forum Discussion
null null
Feb 15, 2018Copper Contributor
Excel 2016: Exclude a specific cell from a range when calculating a median
Hi, I'm new at this and really not a pro with Excel, so hope someone can help me out! I'm pulling data from one workbook into another. The path info is correct, but I'm trying to add totals from co...
null null
Feb 15, 2018Copper Contributor
Hi, I need to add the totals.
One workbook shows each person showing their "projected" and "actuals" sales for each month.
The 2nd workbook shows each person'sales by quarter, so I don't need the "projected" in this workbook. I'm using the sum function, perhaps I'm using the wrong function?
Detlef_Lewin
Feb 15, 2018Silver Contributor
Please provide the sample workbooks with the desired result.