G
Guest
I have a set of data with three columns in order of Year, Amount, Paid by.
The year is 2004, 2005, and 2006, with one year value appearing in each row
of column A. Differnt amounts are listed in the Amount column, and Paid By
contains three different people. I am trying to get a sum of what just one
of those three people paid in 2004 over the entire year, and my goal is to
just return the sum of what tha person paid in 2004. I've tried to enter an
argument that says the evaluation criteria is 2004, the criteria range as the
Paid By, and the sum range as the Amount paid range. I've done this using a
SUMIF, but could only get a total amount paid by the three people and not
just the one person I'm interested in. Can you help?
The year is 2004, 2005, and 2006, with one year value appearing in each row
of column A. Differnt amounts are listed in the Amount column, and Paid By
contains three different people. I am trying to get a sum of what just one
of those three people paid in 2004 over the entire year, and my goal is to
just return the sum of what tha person paid in 2004. I've tried to enter an
argument that says the evaluation criteria is 2004, the criteria range as the
Paid By, and the sum range as the Amount paid range. I've done this using a
SUMIF, but could only get a total amount paid by the three people and not
just the one person I'm interested in. Can you help?