if I am reading what you want correctly and Tab 1 and Tab 2 are different
sheets

=sumif('Tab 1"!A:A,"Name 1",'Tab 1'!C:C)+sumif('Tab 2"!A:A,"Name 1",'Tab
2'!D:D)+sumif('Tab 1"!A:A,"Name 2",'Tab 1'!C:C)+sumif('Tab 2"!A:A,"Name
2",'Tab 2'!D:D)

if you want the C and D columns form the same shet as the equation is in then

=sumif('Tab 1"!A:A,"Name 1",C:C)+sumif('Tab 2"!A:A,"Name 1",D:D)+sumif('Tab
1"!A:A,"Name 2",C:C)+sumif('Tab 2"!A:A,"Name 2",!D:D)


"Rick Champ" wrote:

I'm trying to create a formula that would look in a column of another tab for
one of two last names and if it equaled a name then it would look in another
column for a dollar amount and add it to the cell. For example; If Tab 1
column A equals Champ then add column C and if Tab 2 column A equals Champ
then add column D. Thanks for your help in advance.
--
Respectfully,
Rick Champ