Is it possible to get a Total by Month?

Pamela.Baron

I would like to condense some data that I have based on Month's. I just need the total Quantity.

Brief description-

Date Quantity

1/2/24 50

1/2/24 25

1/3/24 50

January 125

2/1/24 25

2/2/24 50

2/2/24 50

jmyzk_cloudsmart_jp

Hi @Pamela.Baron

By Sheet's formula

=SUMIFS(Quantity:Quantity, Month:Month, Month#)

FYI, Month#'s # is used to designate a Sheet Summary field.

https://app.smartsheet.com/b/publish?EQBCT=806a74a1e71d469f83a580021240c30b

By Report's Summary feature

https://app.smartsheet.com/b/publish?EQBCT=8e142a09e8964c9481ed7957268fd42b

jmyzk_cloudsmart_jp

Hi @Pamela.Baron

By Sheet's formula

=SUMIFS(Quantity:Quantity, Month:Month, Month#)

FYI, Month#'s # is used to designate a Sheet Summary field.

https://app.smartsheet.com/b/publish?EQBCT=806a74a1e71d469f83a580021240c30b

By Report's Summary feature

https://app.smartsheet.com/b/publish?EQBCT=8e142a09e8964c9481ed7957268fd42b

Pamela.Baron

I am getting an #Invalid data type on the Sheet Summary. Does the Month field need to be a date type?

edit: I found a couple of blank cells in the Date, it works great!

jmyzk_cloudsmart_jp

Happy to help!😁 Glad it’s working now!