What is wrong with this formula?

I am trying to summarize the quantities of each different sized container that is also checked as being shipped off-site to use in a dashboard pie chart. I tried the following formula, but I get '#unparseable'. What do I need to fix? Or coincidentally is there a better way, using reports, dashboards, however, to visualize all the items checked off to be shipped by quantities of the varying container sizes?

=SUMIFS([# of Containers]:[# of Containers], [Ship Off-Site]:[Ship Off-Site], 1, [Container Size mL:Container Size mL], 2000)

Find more posts tagged with

Formulas

Reports

Dashboards

Sheet Summary

Accepted answers

IEPE

Hola, creo que solo falta poner correctamente los simbolos de columna ] [ :

=SUMIFS([# of Containers]:[# of Containers], [Ship Off-Site]:[Ship Off-Site], 1, [Container Size mL]:[Container Size mL], 2000)

espero te ayude. saludos

All comments

IEPE

Hola, creo que solo falta poner correctamente los simbolos de columna ] [ :

=SUMIFS([# of Containers]:[# of Containers], [Ship Off-Site]:[Ship Off-Site], 1, [Container Size mL]:[Container Size mL], 2000)

espero te ayude. saludos

acarra02

Muchas gracias! A pensar que la solucion era tan simple y no lo veia.

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.