Try this an alternative, NO ISNA needed:

Assuming "names" in column A (A2 onwards) and "goods" in row, column B onwards

=SUMPRODUCT((Sheet1!$A$2:$A$400="mike")*((Sheet1!$ B$1:$AP$1="widget")+(Sheet1!$B$1:$AP$1="trinket")) *(Sheet1!$B$2:$AP$400))

HTH

"denise" wrote:

Hi Folks,

The formula listed below works great but now I need to include an "if isna"
statement for those incidents where Mike may not have any trinkets or widgets
to sum. I'm hoping someone can help me re-write this so it there will be
fewer characters and I can fit in the "if isna" statement.

=INDEX('sheet1'!$A$1:$AP$400,MATCH("mike",'sheet1' !$A$1:$A$400,0),MATCH("trinket",'sheet1'!$A$1:$AP$ 1,0)))+INDEX('sheet1'!$A$1:$AP$400,MATCH("mike",'s heet1'!$A$1:$A$400,0),MATCH("widget",'sheet1'!$A$1 :$AP$1,0))

Thanks,
Denise