SUMPRODUCT

  • Thread starter Thread starter Brian Thomson
  • Start date Start date
B

Brian Thomson

I currently have a table that is imported from Access and
I wish to carry out some analysis on this. I have read
the forums and SUMPRODUCT seems to be the answer. My
problem is that I have three conditions in the formula
working fine but when I add a 4th it always seems to
return no result.

The formula I have that works is:

=SUMPRODUCT(('[data.xls]Monday'!$C$2:$C$12=B8)*
('[data.xls]Monday'!$AE$2:$AE$12=$C$5)*('[data.xls]
Monday'!$I$2:$I$12))

However, when I add another condition it seems to fail

=SUMPRODUCT(('[data.xls]Monday'!$C$2:$C$12=B8)*
('[data.xls]Monday'!$AE$2:$AE$12=$C$5)*('[data.xls]
Monday'!$AE$2:$AE$12="TRUE")*('[data.xls]Monday'!
$I$2:$I$12))

Is this enough info for anyone to help me???

Thanks
Brian
 
You are trying to sum values in column I, which have on same row the value
in column C equal to value in cell B8, and the value in column AE equal with
value in Cell $C$5, and at same time the value in column AE equal to TRUE.
Unless $C$5 is equal to TRUE, there are no rows which answer to last 2
contitions at same time, and I don't see why do you need additional
condition when $C$5 is TRUE!
 
Back
Top