Morning all,
I have a feeling that SUMPRODUCT is the function I need for this but unsure how best to go about it
I need a formula that will calculate how much money is made, divided by the top row
The dates for this will change ...for example
Cell A1 will contain the start month (which can change)
Cell A2 will contain the finish month(which can also change)
If A1 was Jun and A2 was Feb
I would sum from 1200 to 4506 and multiply it by the numbers directly above.....long winded explanation would be
1200 * 1
1900 * 0.8
2460 *0.8
and so on
Any ideas please ?
Thanks in advance
I have a feeling that SUMPRODUCT is the function I need for this but unsure how best to go about it
Code:
Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb
1 1 1 1 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8
3200 1800 2388 1200 1900 2460 3150 1578 3650 6504 6800 4506
I need a formula that will calculate how much money is made, divided by the top row
The dates for this will change ...for example
Cell A1 will contain the start month (which can change)
Cell A2 will contain the finish month(which can also change)
If A1 was Jun and A2 was Feb
I would sum from 1200 to 4506 and multiply it by the numbers directly above.....long winded explanation would be
1200 * 1
1900 * 0.8
2460 *0.8
and so on
Any ideas please ?
Thanks in advance