Hello all.
Please see the example doc I have uploaded in order to supplement my question:
IF function for “active” column example.ods
I am in need of a formula that states that If a cell in the “ACTIVE?” column reads “YES”, then the adjacent time in the “TIME INVESTED DAILY” column is added to the “TOTAL TIME” column.
Conversely, if the “ACTIVE?” column doesn’t say “YES”, then the figure in the “TIME” column should not be added to the “TOTAL TIME” column.
I think that, To use cell D2 as a starting point, the formula needs to start with something along the lines of =IF(C2= “Yes”, but am not sure where to go from there.
Thanks in advance.