please I need your help

Originally Posted by MSP77079

Assuming you do mean "another column", here is the formula for that:

=SUMPRODUCT(OFFSET(C14,0,0,1,COUNTA(C14:AZ14)),OFFSET(C15,0,0,1,COUNTA(C15:AZ15)))/SUMPRODUCT(--ISNUMBER(OFFSET(C14,0,0,1,COUNTA(C14:AZ14))))

Thanks For your answer, yeah i meant a column, you are right! the problem now is that when i enter this function in Excel, it tells me "The formula you typed contains an error". what could be the problem?

I just copied and pasted it back into my workbook. No error.

So ... I am guessing that the problem is we have different (language) versions of Excel. Try replacing commas (,) with semi-colons (.

It may also be that SUMPRODUCT is a function only available with an Excel Add-In Tool Pack (i.e. Analysis ToolPak). I think that would cause that error as well.

Thanks Weston, I did not think about that.

To test if the function is available, use Insert >> Function, you should be able to find SUMPRODUCT in the Math & Trig category. Or, of course, in All category.