Hiughs wrote:
I've troubles using sumproduct... In the functions assistant the formula
result it´s fine, but when i hit the Ok button the result is #VALUE why?...
This is the formula: =SUMPRODUCT((IF($H$12:$H$14=F1;1;0));($G$12:$G$14) )
Help please...
You don't need SumProduct for you just have one condition. That means
you can invoke a faster ordinary formula:
=SUMIF($H$12:$H$14;F1;$G$12:$G$14)
|