If the table is formatted as a table you won't have to adjust the range if you add new rows/columns either.
If the table is formatted as a table you won't have to adjust the range if you add new rows/columns either.
=SUMIFS([the column you want to sum],[the column you mark as "yes" if completed],"yes") would work
I quite like
=SUBTOTAL(9,[playtime column])
As it will adjust the sum shown as you filter the columns.
=SUMIFS([the column you want to sum],[the column you mark as "yes" if completed],"yes") would work
I quite like
=SUBTOTAL(9,[playtime column])
As it will adjust the sum shown as you filter the columns.