I can't figure out why the unary fails!

Might you explain Bob?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bob Phillips" wrote in message
...
=SUMPRODUCT((Sheet1!B1:M1=A1)*(Sheet1!A3:A20=Sheet 2!B1)*(Sheet1!B3:M20))

adjust the ranges to suit

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Chad" wrote in message
...
Hey everyone, I am not sure what the best way is to handle this so I
thought
that maybe some of you could help point me in the right direction. In
my
worksheet (Sheet1) I have the following data:

Sheet1:

a b c d e
f
1 Promo1 Promo1 Promo2 Promo2 Promo2
2 Week1 Week2 Week3 Week4 Week5
3 Menu Item1 .2 .3 .15 .26
.16
4 Menu Item2 .4 .28 .56 .6
.68
5 Menu Item3 .25 .32 .45 .8
.15

And just to specifiy there are many more promo's and many more menu
items
in
my sheet so this is an oversimplification of the data.

That being said, I would like to sum the data for a specific Menu Item
based
on which promo it falls under. For example:

Sheet2:

a b c
1 Promo2 Menu Item2 1.84


Any help on the best way to do this would be greatly appreciated.

Thanks in advance for all of your help.

Beset,
Chad