Thread: sumproduct
View Single Post
  #1   Report Post  
montypython montypython is offline
Junior Member
 
Posts: 4
Default 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