Hi there,
I'm using OpenOffice Calc (which seems to have many of the same built-in functions as Excel), and I'm looking to perform a SUMIF with using two comparisons, and I'm not quite sure how to do it. I'm wondering if SUMPRODUCT would work better.
In Excel, I've still been unable to do this, so I know it's not a compatibility thing.

I'm doing my step-dad's taxes, and trying to make receipt categorization for his home business easier. He knows not Excel (or Calc) at all, so I'd like to make this stupid-proof.

The spreadsheet is lain out with a numeric code for each category of receipts (office supplies, fuel, repairs, etc), a receipt date, and an amount. Each category needs to be summarized by date. I'd like to make it as easy as allowing him to enter receipts for any category on any day and having Excel (Calc) perform the operation.

I've figured out how to get a summary of all receipts for all months using (pseudocode):

Code:
=sumif(month_column,end of month using next month-1 function, dollar_column)-sumif(month_column,1,dollar_collumn)
and I've figured out how to get a summary of all receipts for all codes using a simple SumIf statement, but I need to combine them. I need a summary of all codes for a given month. I can convert from Excel to Calc, but I just don't know how to get this union working...

Any help would be beyond appreciated, as I've been racking my head for awhile trying to figure this out.

Thanks ahead of time.