SUMIFS Help Request

[dtucker2003]

Hey Folks, I am Needing a little Help with sumifs or OPEN to Suggestions...

I have a Table that has All my data (its Called Table1) it has Headings...
I needing to Sum one Column (Table1[miles] but i need to match Critera
(Table1[Name]) & (table1[Date]).

The Part im having trouble with is doing a Date Range,

current known, =sumifs(table1[miles],table1[name],a2,???DateRange???)


"a2" is my the Name im Pulling, but what has me Stumped is the Date range. i have my Date Range on the Sheet in b1=Starting Date and c1=Ending Date

----Any Help Would be Great----

Thanks

 

[anandvarma]

post some sample data

 

[dtucker2003]

Ok I have Included a Images...

 

[anandvarma]

try this


=SUMPRODUCT(--(table1[Name]="David T.")*(table1[Date]>=$B$2)*(table1[Date]<=$B$2)*(table1[Miles])

 

[dtucker2003]

Ok, i have Tried all i get is Zero's..
I am also confused with the sumproduct formula since what i what i want to Sum is the [Miles] for a Specific [Name] on specific [Daterange]...

I have Set the Date Ranges to pull from as well as the Name... becasue i am trying to do this for a entire year and for 20 people, thought i could use some Autofill to make it easier... .



I have Attached the Document to Google Docs so that you can See true document

https://docs.google.com/leaf?id=0B5...Y2Q3ZS00ZDEzLWE4NjUtYzQyODljMjZiMGQz&hl=en_US

if you want i can Send the Document if Google Docs is Giving Trouble..

Also Thanks for all that your Doing to Help me with the Issue...