Forum Discussion

User537843's avatar
User537843
Copper Contributor
Feb 06, 2023

COUNTIF, but more complicated

Hello, thank you everyone for your help. I have 2 columns, a date on the left cell, the payment $ on the right cell, and the column is long, goes down many cells, with the same pattern. I need to make a total of the payments, but must be separated by the year of the payment date. Above these 2 columns, I need a list of years in the left column, and a list of payment totals in the right column, only if the payment happened in the specific year on the left. I have attached a screenshot example of this problem, Thank You.

 

Also, I see other posters can set their photo to display, but when I upload a photo, it does not display here, it is only available for viewers to download. How do I display the photo directly?

  • User537843 

    =SUMPRODUCT((YEAR($B$10:$B$27)=B2)*$C$10:$C$27)

    You can try SUMPRODUCT.

     

    There is a button which i can click to choose which screenshots i want to upload.

Share

Resources