Germanator
New Member
- Joined
- May 15, 2023
- Messages
- 1
- Office Version
- 2021
- 2010
- Platform
- Windows
Hello, I have created a Google Sheets document where i track all of my stocks (purchase/sale price, dividends, etc). I have created a tab for each stock where i record each transaction by date. I would like to create a Dividend Summary tab that can pull the data from the stock tabs to show dividends by date. For example, i would like to know how much dividends i collected in May of 2020. The date and the dividend amount are on separate columns (date is column a and dividend in column c). The date is formatted 5/23/2020. So i would like to pull the cells value in column c if the date in column a is equal to month 5 and year 2020. Is this possible?