Hi there everyone.
So I have a tracker sheet that i've built to track jobs that are due day to day, but we now need to start tracking how much time spent per day on each job. So i set up columns W-AB for people to write in duration for every day of the week, and one for weekends (though hopefully nobody has to use that one), and column AC is for totals. What I'm trying to do is make sure that if all the days of the week are left blank, then the sum column stays blank too, because i have a master page that compiles everyone's info for the week onto one sheet, and i don't want it adding blank rows because there's a formula in one column that keeps returning 0.
So, i tried the usual IF function, but i couldn't make that work with multiple columns for some reason.
I tried SUMIF [=SUMIF(A1:E1,">1",A1:E1)], but that kept on returning 0, no matter what I tried as the criteria.
I'm sure whatever i'm missing is a minor mistake somewhere, but I haven't been able to find anything posted in the forum that fixed the problem. Any help would be greatly appreciated.
Thanks
P.S. Sorry, I wanted to upload my excel doc, but i couldn't get the upload button to work.
Bookmarks