Hi, I'm working on making myself a good Spreadsheet for my Crypto Taxes.
I found this free spreadsheet here which I want to improve (not allowed to publish links, so I separated them:
Blog Article: tokeneconomy. co/crypto-tax-calculation-via-google-sheets-fifo-abc-584a11a3da22
Spreadsheet: docs. google. com/spreadsheets/d/1PBRyOlLQLH7bzP55XB2hQfAFQSA3YbyTv9kKy6XOlWU/edit#gid=0
To make this fit my own country's laws, I have added another sheet in the spreadsheet where I want to track the profit/loss for every asset/coin for each year. So far I have managed to get it working to sum this without any year argument in this query:
=SUMIF(Tax!A:A,A5,Tax!V:V)
But when I'm trying to add from/to date for selection within years, it seems like SUMIF doesn't allow that many arguments. I tried with this query which failed:
=SUMIF(Tax!A:A,A25,Tax!V:V,Tax!F:F,">=1/1/2019",Tax!F:F,"<1/1/2020")
"A25" is from the new sheet where I have listed my assets like BTC, ETH, LTC etc. A25 changes dynamically based on the row I put the query into so I don't have to change the argument into BTC or ETH or whatever I want to select. So instead of A25 I could have used "*BTC*" or "*ETH*".
Anyway, my main problem is adding all of these arguments in a single query. Do you have any suggestions?
If you need any access to the spreadsheet I'll make a copy for you.
Bookmarks