Sheet Summary Formula

Josephine

Ok I have 3 sheet summary formulas that I am trying to make into 1 formula - is this possible?

=COUNTIFS([ESG Core - 4 units to pass]:[ESG Core - 4 units to pass], >=4, [Start date]:[Start date], <TODAY(-180))

=COUNTIF([Start date]:[Start date], <TODAY(-180))

=SUM(ESG# / [ESG %]#) * 100

It works as 3 but would look tidier in the sheet summary and be less confusing as 1 formula. Any suggestions?

Ipshita

Hi @Josephine - Yes, it is possible. Just create another summary sheet field that takes the sum of all of these 3 separate summary sheet formulas - =SUM() in the brackets, just select the summary fields you want to add into one.

Hope this helps,

Thanks,

Ipshita