Vlookup and SUMIFS

**ASPERO** · 07-15-2011, 12:07 AM

Hi

Is there any way to combine Vlookup and SUMIFS? I need to sum the results displayed in a specific row if that row matches certain conditions.
Thanks a lot.
M

I'm enclosing an example.

**Azam Ali** · 07-15-2011, 12:35 AM

Hi ASPERO

there could be many ways. Kindly upload a sample work book for solution of your problem.

**ASPERO** · 07-15-2011, 10:00 AM

Hi
I have already uploaded an example of what I need to do.
Thanks a lot for your help.
M

**NBVC** · 07-15-2011, 10:07 AM

Try something like:

=SUMPRODUCT(('Games per Team'!$B$5:$B$11=I5)*('Games per Team'!$C$4:$EE$4>=DATE(2008,3,1))*('Games per Team'!$C$4:$EE$4<=DATE(2009,11,1)),'Games per Team'!$C$5:$EE$11)

copied down.

You can replace the DATE() functions with Cell references containing the START/END dates of interest... (note that since you list the dates in Games Per Team sheet as first of each month, then the cell references should be the same to ensure you get all the data you need).