How do you add an ISNUMBER() into a formula to return 0 for cells with no data

[OllieR]

Hello,

I have this formula that sums columns depending on two criteria. It works perfectly, until there is no data in the cell. What I would like to do is add an ISNUMBER check to the index data so that the function will work without returning errors and return 0 if there is no data in a cell. Here is the formula:

=IFERROR(INDEX(MMULT(TRANSPOSE(Table1[[Lemons]:[Apples]]),1*(Table1[Project Release]=FruitOrVeg)),MATCH(B3#,Table6[[#Headers],[Lemons]:[Apples]],0)),0)

Thanks for the help.

[AliGW]

Welcome to the forum.

ISNUMBER may NOT be the best solution.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

[curiouscat408]

It works perfectly, until there is no data in the cell.

I'm not sure what "the cell" is. Perhaps:

Please Login or Register  to view this content.