Sheet Summary Formula Count

Melanie Sanders

Hi I am trying to create another formula in a sheet summary that reflects orders from several years in the past and to count how many there were based on my orders column.

I have this formula in but it doesn't work.

=COUNTIFS([ORDERS]:[ORDERS]),"YES - 2017" [ORDERS:ORDERS],"YES - 2016")), [ORDERS:ORDERS],"YES - 2015)))

Any help is greatly appreciated.

Andrée Starå

Hi,

Try something like this.

=COUNTIF(ORDERS:ORDERS; "YES - 2017") + COUNTIF(ORDERS:ORDERS; "YES - 2016") + COUNTIF(ORDERS:ORDERS; "YES - 2015")

The same version but with the below changes for your and others convenience.

=COUNTIF(ORDERS:ORDERS, "YES - 2017") + COUNTIF(ORDERS:ORDERS, "YES - 2016") + COUNTIF(ORDERS:ORDERS, "YES - 2015")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma."

I hope that helps!

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!