Post the *exact* formula you tried. Toppers formula should work. If "Mike"
or "trinket" or "widget" does not exist the formula will simply return 0.

Are there any errors in the range?

Biff

"denise" wrote in message
...
Hi Toppers,

Well I just keep getting a #value error with your suggestion. I've tried
it
by referencing a sheet where I know the result should be 9 and also with a
sheet where Mike does not appear although the trinket and widget columns
do.
Both give me the value error.

The reason I need to add the isna is because sometimes mike will have
results for a widget, sometimes a trinket, sometimes both, sometimes none,
and sometimes mike won't even be on the daily list so it's pretty much an
either/or situation.

Thanks,
Denise

"Toppers" wrote:

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