What am I doing wrong - SumIf referencing specific cell

This is my formula =SUMIFS({Time in hours}, {QA}, [Primary Column]@row, {Task}, $[Column3]$8)

It works perfectly in the first cell of the column but when I try to turn it into a column formula I get an error of the syntax isn't quite right. No matter what row in the column my formula is in I want it to reference Column3 cell 8 but want the other references to be flexible.

Find more posts tagged with

Accepted answers

All comments

Mike TV

@Hollie Green

You cannot have an absolute reference in a column formula. As a work around, create a Sheet Summary formula with the absolute reference call. Then in your column formula build out the formula to refer to the sheet summary.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.