Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using SUMPRODUCT
Based upon response to an earlier question, I'm attempting to use SUMPRODUCT
to create a synopsis formula. However, when I am entering the array, the formula box Formula Result=0 though I know there are True cells within the range. The formula I am using is: =SUMPRODUCT((Log!B3:B80=1997)*(Log!D3:D80=17)) where the answer should be 1. In the case of both arrays, the result set forth to the right of the array box reads "false; false; ...". I have tried the formula with and without the quote marks ("1997"). I even tried it by removing all but the year from the date column. I have also tried formatting the date column as Text rather than Date. All to no avail. HELP! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT help | Excel Worksheet Functions | |||
Another Sumproduct & #N/A problem | Excel Worksheet Functions | |||
Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |