• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sumproduct

Leovilla

New Member
Friends, good evening
I'd like your help, how to solve the problem of my sum, I wanted the sum to be only of the current year (2024)
Thank you
 

Attachments

  • Pasta4.xlsx
    14.7 KB · Views: 3
Thank you very much for your help, but can you adapt this formula if you have other folders, plan2, plan3, and change as I need.
I changed the spreadsheet for you to see.

Thank you
 

Attachments

  • Pasta4(2).xlsx
    25.1 KB · Views: 2
using pivots
Row LabelsSum of Vl
2023
15​
2024
507825​
Grand Total
507840​
 

Attachments

  • Pasta4.xlsx
    21.3 KB · Views: 2

Leovilla

My sample is interesting in Table's name as You could see.
= You can modify formula's Tabela1 to others Table's names as You need.
 
Back
Top