Summary formula vs Column formula: Incompatability issue?

Teresa Walters Roszkowski

I have several grid sheets that have SUMIF summary formulas running.

I’m working on a new sheet that requires I split the date & time that are included in one column. Summary formulas I would ordinarily run on the Program Start Date no longer work. Am I correct in assuming the summary formula will not operate on a column that includes a column formula? Is there a work around for this?

JamesB

@Teresa Walters Roszkowski

You are correct that it will not work on a column formula, because your summary formula is being replaced by your column formula. When I need summaries for columns where I have a column formula, I either put a formula in the sheet summary, or I create a separate cross-reference metric sheet to gather the data. If your data is indented to have Parents/Children, there are some options there for a column type formula with summary. Hope this helps.

JamesB

@Teresa Walters Roszkowski

You are correct that it will not work on a column formula, because your summary formula is being replaced by your column formula. When I need summaries for columns where I have a column formula, I either put a formula in the sheet summary, or I create a separate cross-reference metric sheet to gather the data. If your data is indented to have Parents/Children, there are some options there for a column type formula with summary. Hope this helps.

Teresa Walters Roszkowski

Great insight! Thank you so much!