re: ignore text in array formula 2

I do not fully understand what you are trying to do,
but this seems to work with gnumeric 1.10.16:

In column H:


1) check for a number,
   if true use number,
   if false use 0
2) then multiply

Simplified... this also works:



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]