Forum Discussion
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 columns C, E, G, without adding totals from columns D and F, is there a way to do this? thank you,
Begin by using the AGGREGATE function.
Then its just a matter of selecting your ranges or preferably the fields if using a Table.
Hi,
do you want "adding totals" or "calculating a median"?
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?
Please provide the sample workbooks with the desired result.
