Richard Marks
New Member
- Joined
- Jun 26, 2008
- Messages
- 3
Hi , new to using Subproduct & having problems
I have set-up a test with 2 arrays of only 2 cells (to test).
Both are conditions.
When I look in the function arguments the two arrays show results
"False;True" & "False;True" for my 2 test cells
I thought the result of
SUMPRODUCT should be "1" , ie false*false (0) + true*true (1) = 1
I need to resove this before I move to using this formula for my real work.
Any advice welcomed.
Thanks
Richard
I have set-up a test with 2 arrays of only 2 cells (to test).
Both are conditions.
When I look in the function arguments the two arrays show results
"False;True" & "False;True" for my 2 test cells
I thought the result of
SUMPRODUCT should be "1" , ie false*false (0) + true*true (1) = 1
I need to resove this before I move to using this formula for my real work.
Any advice welcomed.
Thanks
Richard