Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Problem using sumproduct
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... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with sumproduct and month=1 | Excel Worksheet Functions | |||
Sumproduct Function problem | Excel Worksheet Functions | |||
Another Sumproduct & #N/A problem | Excel Worksheet Functions | |||
SUMPRODUCT Problem | Excel Discussion (Misc queries) | |||
SUMPRODUCT problem | Excel Worksheet Functions |