I’m trying to find the average of steps taken each day of the week. I’ve exported my stats from fitbit, which include steps taken, and are accompanied by the date. 1st step: find which day of the week these dates correspond to. I did this by creating a new column, and did =TEXT(A1, "DDDD"). With that working, now I use =SUMIF(column with days of the week, "Monday", column with steps taken). This should look for the word Monday, and if so, add up all steps in the steps column.
However, it just returns “0”. I’m stumped and have no idea what’s going on. Any ideas?
