Hi,

Ik have, I think, two simple questions. If you could help it woul be perfect
1. If you use the sumif function, is it possible to use a variable for the criteria. Example: =SUMIF(G12:G211;">B4";H12:H211). In this example B4 is the criteria. This criteria can be changed in cell B4 (the critearia is a number). If I do this the sum is always 0. Is there a solution for this.

My second question is:
If you have a second order polynomial is it possible to calculate the a, b and c value in separate cells. This is possible for a first order (straight line) for the a and b value.

Thanks in advance for you reactions.

Regards,
Niels