I am making an excel sheet to display hours worked for the total pay that it is for and then figure out what the hourly rate would come out to for example:
In Out Hours Pay Rate per hour [c] [d] [e] [f] [g]  12pm 3pm 3 18 $6  .. .. .. .. ..  .. .. .. .. ..
This is all working fine and heres where my problem is. I set up a grand totals box for each column: hours, pay, rate.
It will work fine if I use this:
So this will end up changing the Grand Total for hours to number format, something like 7, 8.23, 9.5, etc.
When I try to do it for all the cellss in that column though:
I get an error. How do I make it so it will add it like it does for the single cell but for each different cell. So after each iteration I want it to change the cell number if that makes sense.
Hope someone out there can help me with this and I appreciate any help! Thanks!