Hi!

Try this:

=3DSUMPRODUCT(--($H$12:$H$14=3DF1),$G$12:$G$14)

OR

=3DSUMIF($H$12:$H$14,F1,$G$12:$G$14)

Biff

-----Original Message-----
I've troubles using sumproduct... In the functions=20
assistant the formula=20
result it=C2=B4s fine, but when i hit the Ok button the=20
result is #VALUE why?...=20
This is the formula: =3DSUMPRODUCT((IF($H$12:$H$14=3DF1;1;0));
($G$12:$G$14)) =20
Help please...
.