Excel vlookup with filters

[neolace]

Hi There,

Please see attached xls for sample.

The values in red needs to be summed because col a and col c we're matched with a filter.

So, If I need the sum of the rows where col a is x101 and the date is 2010/04/21, what formula or vlookup would be reguired to get this sorted.

I need to setup a list of summary items with the totals as requested.

Please help.

Thank you

[NBVC]

=Sumifs($B$6:$B$14,$A$6:$A$14,A23,$C$6:$C$14,"4/21/2010")

Better if you put the date to sum in a cell too...

[davesexcel]

Check out Sumproduct