It looks like you're trying to use the SUMPRODUCT function in Excel to calculate a specific value based on the ranges you've indicated. However, your function seems to have a small typo.
The correct syntax for SUMPRODUCT would involve using ranges that can be interpreted correctly by Excel. If you want to multiply the values in columns B and E together and then sum those products, you would specifically refer to the ranges.
Based on your cell assignments:
- B2 = 3
- B3 = 4
- E2 = 9
- E3 = 10
The SUMPRODUCT function should be structured like this:
=SUMPRODUCT(B2:B3, E2:E3)
This function takes the values in B2 and B3, multiplies them by the corresponding values in E2 and E3, and then sums the results.
Calculating it manually:
- (3 * 9) + (4 * 10) = 27 + 40 = 67.
So the result of this SUMPRODUCT calculation will be 67.