Can I SUMIF with the vlookup cell data?

I have:

File 1: cell 1 is populated with a number via a vlookup formula in that cell

file 2: I want to sumif the data in file 1, cell 1.

Will SS be able to do that calculation? Will it see the numeric value in the cell or will it give an error as it only sees the formula?

Find more posts tagged with

Accepted answers

All comments

Eric Law

@KimTDSYN SS should be able to, but it is wonky sometimes.

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.