lucyclark83
New Member
- Joined
- Aug 19, 2016
- Messages
- 10
Hi,
This is more of an interest than a requirement to be fixed, but I have a google doc spreadsheet, one of the sheets calculates quarterly averages using the below formula:
=sum((MTD!C63:D63+MTD!C83:D83+MTD!C104:D104)/13)
I can't understand why it's using a range, i.e. C63:D63 as the different columns relate to 2 different people.
I've amended a couple of the cells to this =sum((MTD!C4+MTD!C20+MTD!C36)/13) to reflect just one person, and checked the results, and I'm getting the same answers, so its more out of interest why the range is being used?
I didn't set the sheet up originally, but something I use daily so this is more an interest
Thanks to anyone that can shed any light
This is more of an interest than a requirement to be fixed, but I have a google doc spreadsheet, one of the sheets calculates quarterly averages using the below formula:
=sum((MTD!C63:D63+MTD!C83:D83+MTD!C104:D104)/13)
I can't understand why it's using a range, i.e. C63:D63 as the different columns relate to 2 different people.
I've amended a couple of the cells to this =sum((MTD!C4+MTD!C20+MTD!C36)/13) to reflect just one person, and checked the results, and I'm getting the same answers, so its more out of interest why the range is being used?
I didn't set the sheet up originally, but something I use daily so this is more an interest
Thanks to anyone that can shed any light
