Calculating 2007 Commissions vs 2006?

[DukeVBall]

Hey everyone,

I'm in retail real estate and I keep track of my commissions on excel. In leasing we get paid at lease signing, then when the tenant opens. The first check could be in 2006 and the second 2007. However, I'm trying to track my 2007 earnings without having to delete or zero out my 2006. Otherwise, when I sum the total, I get 2006 and 2007 numbers.

This is what I was trying to do:

If the date commission is paid falls between 1/1/2007 and 12/31/2007, then add it. If it does not, disregard it or make it 0.

I want to have a sum that pulls the amount earned from 2007...if anyone could think of a way to do this, please let me know. I can send a sample of my worksheet.

Thanks in advance.
dukevball @ gmail.com

[Ron Coderre]

With
Col_A containing dates, A1: DatePaid
Col_B containing commission amounts, B1: Commission

This formula returns the total commissions paid in 2007:
=SUMPRODUCT((YEAR(A2:A100)=2007)*(B2:B100))

Is that something you can work with?
(post back if you have more questions)