Need cells to remain blank until figures filled in the related cells

Hi and thanks for taking the time to read my question

I am working on a sheet in which i record hours worked and jobs done by different members of my team as you should see by the attached file i have managed to get the totals for the days of the week to add up ( =SUM(C3,E3,G3,I3,K3,M3) ) easy enough) but i am struggling with keeping the total column ( O3,O4,O5 ETC..) BLANK until i enter the daily figures in.

Im sure its easy enough but my brain is having a meltdown.

Many thanks in advance Phil

Working hours.xlsx

Hi,

Try the following in O3:

=IF(AND(C3<>"",E3<>"",G3<>"",I3<>"",K3<>"",M3<>""),SUM(C3,E3,G3,I3,K3,M3),"")

Hi

this formula worked a treat many many thanks to both of you

Phil

Modify the formula in O3 as following:

=IF(C3<>"",SUM(C3,E3,G3,I3,K3,M3),"")

P3:

=IF(D3<>"",SUM(D3,F3,H3,J3,L3,N3),"")

Thanks for the rep!

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.