Getting #VALUE! from formula that contains range

  • Thread starter Thread starter Jan
  • Start date Start date
J

Jan

I have the following problem:

I need a formula wherein a summation happens of different IF's. When I
make the formula in the edit box (function arguments ('Fx' in formula
bar)) I see the result of my formula. But in the cell the result is
#VALUE! . I tried something similar but easier and the same happens, I
give the example formula:

=SUM((A1:D1)*(A2:D2))

What can I do about it or is it just happening to me?

Hope somebody van help me, thanks a lot!

Jan
 
Back
Top