Hi everyone,

This has probably been asked before, but I can't seem to find it anywhere on the forum, so apologies in advance if it is.

I have a table which has dates when prizes are issued in column A, the value of prizes in column B and dates the prizes are redeemed in column C.

I want to work out how many prizes have been issued in a certain month that have been redeemed in that month or another month.

The prizes have to be redeemed within six months, otherwise they expire. So, for example, prizes issued in July 2013 can be redeemed in July, August, September, October, November and December.

I have set up a seperate sheet with separate colums for each month the prizes are issued, and separate rows for each month the prizes are redeemed. What I want to do is, for example, enter a formula that returns the sum of the value of all prizes issued in July 2013 that are redeemed in September 2013.

Thanks in advance for any assistance.