Prev Previous Post   Next Post Next
  #1   Report Post  
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sumproduct instead of SumifS in VBA (application.sumproduct) Majken Bilslev-Jensen Excel Programming 7 December 30th 10 05:56 PM
Sumproduct with Condition OR Sumproduct with ADDRESS function - HE gholly Excel Discussion (Misc queries) 2 September 28th 09 05:07 PM
Conditional SUMPRODUCT or SUMPRODUCT with Filters Ted M H Excel Worksheet Functions 4 August 14th 08 07:50 PM
sumproduct? sumif(sumproduct)? David Excel Worksheet Functions 3 July 13th 07 07:06 PM
sumproduct mod row denise Excel Worksheet Functions 9 February 27th 07 08:58 PM


All times are GMT +1. The time now is 01:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"