Ask a New Question
Menu

B2 is 3 , B3 is 4 , E2 is 9 and E3 is 10.

find the =sumprocduct(B2:E2,B3:E3)

1 answer

To find the value of the formula =SUMPRODUCT(B2:E2, B3:E3) using the values you've provided:

  • B2 = 3,
  • B3 = 4,
  • E2 = 9,
  • E3 = 10.

First, you need to identify the full ranges in B2:E2 and B3:E3. Given the provided values, let's clarify the contents of those ranges:

  • B2:E2 contains the values (3, E2, E2, E2), which means:
    • B2 = 3
    • C2 = E2 (let's assume it's 9 though it wasn't provided)
    • D2 = E2 (assumed to be 9)
    • E2 = 9

So, we can fill in the values:

B2:E2 = (3, 9, 9, 9)

For B3:E3, you presented:

  • B3 = 4
  • C3, D3, E3 are not given explicitly, but based on E3 = 10 (let's assume the other values are consistent with those in the first row):

So: B3:E3 = (4, 10, 10, 10).

Thus the formula =SUMPRODUCT(B2:E2, B3:E3) will result in:

\[ = (3 * 4) + (9 * 10) + (9 * 10) + (9 * 10) \]

Calculating:

  1. \(3 * 4 = 12\)
  2. \(9 * 10 = 90\) (for each of the three remaining terms)

Now add them together: \[ = 12 + 90 + 90 + 90 \]

This results in: \[ = 12 + 270 = 282 \]

Thus, the final value of =SUMPRODUCT(B2:E2, B3:E3) is 282.