sumproduct
Hi I am having a problem with a table I have created
I am using multiple criteria I need to add up totals per person per item if you get what I am saying, The formula comes up with no errors, but it is not finding ding anything
=SUMPRODUCT(--(Data!Driver=Variances!A$3)*(Data!Fleet=Variances! B$2),Data!Variance)
Any thoughts?
Thanks
|