I have opened up a worksheet that a coworker created last year and cannot
figure out the purpose of the isnumber function in this formula:
{=SUM(N27:N117*P27:P117)/SUM(N27:N117*ISNUMBER(P27:P117))}.

I have looked it up in Excel help and on Google with little insight. If
anyone can please tell me what the purpose of this function is/does, it will
be greatly appreciated. The data it is pulling from is all numbers.

Regards,

Jon

It's either being used as an error checker or as a way to check for blanks.

For instance, if text appears in the P27:P117 range, it would normally cause
the whole formula to fail. The isnumber function prevents that from
happening, telling the denominator to ignore any number in N27:N117 that is
associated with a nonnumber in the P range.

Also, ISNUMBER returns a False for blank cells. So, the formula also
excludes any N27:N117 number that is associated with a blank cell in the P
range.

Looking at the whole formula, this is what appears to be happening. He wants
to divide by the sum of numbers in the N range that have a number in the P
range.

Hope that answers your question.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jon" wrote:

I have opened up a worksheet that a coworker created last year and cannot
figure out the purpose of the isnumber function in this formula:
{=SUM(N27:N117*P27:P117)/SUM(N27:N117*ISNUMBER(P27:P117))}.

I have looked it up in Excel help and on Google with little insight. If
anyone can please tell me what the purpose of this function is/does, it will
be greatly appreciated. The data it is pulling from is all numbers.

Regards,

Jon

THanks LUke.

That helped a lot.

Cheers,

Jon

"Luke M" wrote:

It's either being used as an error checker or as a way to check for blanks.

For instance, if text appears in the P27:P117 range, it would normally cause
the whole formula to fail. The isnumber function prevents that from
happening, telling the denominator to ignore any number in N27:N117 that is
associated with a nonnumber in the P range.

Also, ISNUMBER returns a False for blank cells. So, the formula also
excludes any N27:N117 number that is associated with a blank cell in the P
range.

Looking at the whole formula, this is what appears to be happening. He wants
to divide by the sum of numbers in the N range that have a number in the P
range.

Hope that answers your question.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jon" wrote:

I have opened up a worksheet that a coworker created last year and cannot
figure out the purpose of the isnumber function in this formula:
{=SUM(N27:N117*P27:P117)/SUM(N27:N117*ISNUMBER(P27:P117))}.

I have looked it up in Excel help and on Google with little insight. If
anyone can please tell me what the purpose of this function is/does, it will
be greatly appreciated. The data it is pulling from is all numbers.

Regards,

Jon