SumIf and Vlookup together?

[cmillls45]

I'm having trouble determining what formula I need, maybe vlookup an
sumif together? I've never done that before. I need to get the sum o
two numbers in a different tabs but have some criterea. The situation i
that a vendor can either pay via check or cash each month. My summar
tab as well as my other tab that has the info have all the vendors o
them (spelled the same). My vlookup would be by vendor, but there coul
be payments for 2011 or 2012 (year is a seperate column). I want to su
all 2012 payments (cash and check) by vendor. I don't want to create
pivot table as I want this to auto calculate.

Tab Vendor Year Check Cash
January Smith Company 2012 $100 $200
February Smith Company 2011 $300 $50
March Smith Company 2012 $200 $200

The total on the summary tab for Smith Company for all 2012 payments fo
the months of Jan - Mar would be $700.

Thanks
Chri

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Spencer101]

I'm having trouble determining what formula I need, maybe vlookup an
sumif together? I've never done that before. I need to get the sum o
two numbers in a different tabs but have some criterea. The situation i
that a vendor can either pay via check or cash each month. My summar
tab as well as my other tab that has the info have all the vendors o
them (spelled the same). My vlookup would be by vendor, but there coul
be payments for 2011 or 2012 (year is a seperate column). I want to su
all 2012 payments (cash and check) by vendor. I don't want to create
pivot table as I want this to auto calculate

Tab Vendor Year Check Cas
January Smith Company 2012 $100 $200
February Smith Company 2011 $300 $50
March Smith Company 2012 $200 $200

The total on the summary tab for Smith Company for all 2012 payments fo
the months of Jan - Mar would be $700

Thank
Chri

Depending on which version of Excel you're running, you can do this wit
SUMPRODUCT or SUMIFS

Although as you have a worksheet for each month a summary workshee
would make things easier

Happy to help you set this up if you can provide an example workbook

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[cmillls45]

In your sample workbook would Smith (for example) have figures fo
multiple years on the Jan worksheet? So a 2011 value and a 2012 value?

I should have been more clear. No each tab would only have one year pe
vendor

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[cmillls45]

Can anyone think of a solution

+-------------------------------------------------------------------
+-------------------------------------------------------------------