Thread: Array Question

Hi everybody,

I am currently working on a file where I have 2 periods (forecast period and actual period) divided in 4 quarters. In each of these quarters, I know the amount of customers, price per product and products per customers (in this case, the product is apple). With this information, I can calculate the revenues (customers * price per product * product per customer).

However, I want to see the revenue difference in both periods (actual compared to forecast) without calculating this every quarter. I have attached an example of my problem.

I have some difficulties with this, because I can not calculate the average of customers / rate / usage. I think this can be done with an array function, but I don't know how to use this.

Can you help me out please?

Thank you in advance!

Regards,
Gertjan

You've transposed the digits in your result value I believe ie should be 3045 rather than 4035 ? In which case perhaps:

=SUMPRODUCT(((C9:F9)*(C10:F10)*(C11:F11))-((C3:F3)*(C4:F4)*(C5:F5)))