What is wrong with this formula?

acarra02

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)

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

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.