I am trying to take the data from one sheet and give a value in a second
sheet.

For example, I have the following data.
PAID WHEN HOW
$13.00 Jan Check
$52.00 Jan Check
$11.88 Jan Cash
$13.00 Jan Cash
$13.00 Jan Cash

I want to get the following values on the second sheet:
2007 Collected Cash Check
Jan $102.88 $37.88 $65.00
Feb $0.00
Mar $0.00


This is the formula I currently have but need to elaborate on it:
=SUMIF('2007'!D6:D85,"=Jan",'2007'!C6:C85)

This will only give me the information for the amount collected (total) that
has a WHEN = JAN. I would like to know what the value is if the WHEN = JAN
and the HOW = CASH.

I don't know if I need to use a different function.

Thanks, Karen