PRODUCTIF function

Originally Posted by igesta

Hi,

I'm using Excel 2000

if there are SUMIF and COUNTIF, is there anyway to make something like PRODUCTIF??

Basically, I'd like to multiply few cells but the cell locations are random (like A1, C4, G12) and they could be number or string (keep changing). I only want to multiply those number cells, ignoring the string cells.

Any ideas?

Thanks..

Hi,

I think I failed English, I certainly failed Reading and Comprehension.

How will you determine which cells are to be multiplied together?
A1, C4, G12 is a somewhat wide spread - is there a pointer to how many cells and in what Range they will be?

You can Sum column A, multiply that by the Sum of column C, and again by the Sum of column G -
or
you can multiply the cell pointed to in A1 by the cell pointed to in A2 and again A3

How would define a 'string' - a Text item? - some text looks like numbers, how will you define what to multiply and what to leave?

---

I think something like the following is required entered as an array shft ctrl then enter

=PRODUCT(IF(ISNUMBER(A1:A5),A1:A5,1))

but as the range is not continuous eg a1, c4, g12 in the example it will not work as an array, so am stuck.

it could be if(isnumber(a1),a1,1)*if(isnumber(c4),c4,1)*if(isnumber(g12),g12,1)

so if the values were 2, yes and 3 the answer would be 6

Not sure if that helps

Regards

Dav