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! |
#2
|
|||
|
|||
Hi
If I understand this right: 1997 has nothing to do with a date (unless the date is june 19 1905). 1997 has to do with the YEAR of a date. =SUMPRODUCT((YEAR(Log!B3:B80)=1997)*(Log!D3:D80=17 )) HTH. Best wishes Harald "Helen McClaine" <Helen skrev i melding ... 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! |
Reply |
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 |