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...