sumif with a variable criteria and polynomial problem

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

=SUMIF(G12:G211;">"&B4;H12:H211).

For the second bit i will have to think about that, I am not sure exactly what you mean

Regards

Dav

Hi Dav,

Thank you very much for your solution. Works perfectly. With respect to the second question, For example: If you have a first order polynomial (straight line), you can determine the a and b value in y = ax + b by using the "slope" and "intercept" command. If you have a second order polynomial in the form: y = ax^2 + bx + c, how can you detrmine the a, b and c value in the same way as the first order polynomial.

I hope I am a little bit more clear. If you have an answer, it would be great.

Niels

Its hard to give you an answer, but look at the function linest in the Excel help, it will perform multiple regression, so can perform polynomial regression if you also create the squared term. It will give you the things you require. However the answer is returned as an array, so you may need to usesomething like and index function to get the values

Something along the lines of
=INDEX(LINEST(C76:C79,D76:D79,TRUE,TRUE),1,1)
=INDEX(LINEST(C76:C79,D76:D79,TRUE,TRUE),1,2)
=INDEX(LINEST(C76:C79,D76:D79,TRUE,TRUE),1,3)

Regards

Dav