I have a spreadsheet with many rows of time totals as the following example
Cell 1 - 08:00 AM Cell 2 - 1:00 PM Cell 3 - 5:00
Cell 3 is just the total, and I have no problem with this aspect... However I have two columns of the above format side by side... and the only way I can sum Cell 3 on both columns is something like the following:
=sum(c1+c2+c3+f1+f2+f3...etcetcetc...
This can end up in a large formula, and I was just wondering if there was a more efficent way? I tried the following but get a #value! error.
=SUM(C1:C6)+(G1:G6)