Daily Reading Tracker Page counting
Hello, I created a reading tracker in the beggining of the year because I wanted to see which days I was reading and how much, so I made the columns for each month and date, and I added a tracker for the total data for each book.
Link for the sheet (https://docs.google.com/spreadsheets/d/1b\_f7OdUxkI\_Clmh2lm3JaE9se8ozveT-55dDGkpXzfQ/edit?usp=sharing)
The problem since I put each month in a different column I'm not sure how to make the formulas sum the months based on the book titles for all the months so what I've been doing is a continuous sumif like this:
=SUMIF(K:K,X6,L:L)+SUMIF(O:O,X6,P:P)+SUMIF(S:S,X6,T:T)
Which is not very good because I have to manually add each month and I wanted the sheet to be automatic, so I wanted to know if there is a formula that I can use that would count based on the book name, like if this book name is found add the amount in this cell, the same would work for the hour read column.
I searched extensively but most reading trackers insert the amounts manually and once they're finished, I wanted the sheet to count it for be based on the days that the books were read.
I also read a lot on the kindle and sometimes I only have the read amount in percentage and I was thinking if it was possible to make a calculator that would count the latest read percentage and inform me the amount of pages read in the session, I thought I could use a drop down that would auto populate the read pages and the total book pages, insert the percentage read and the formula would calculate (I still have to do the auto population part) but if anyone has a better way of doing this please let me know!