Try this:

=SUMPRODUCT((MONTH('Raw Data 2007'!A2:A64868)=1)*('Raw Data 2007'!
B2:B64868="XIAPPLXRP110")*('Raw Data 2007'!D2:D64868))


On Dec 10, 12:55 pm, Amber wrote:
I am needing to combine multiple functions, I believe, but am in need of some
help. I currently have a document that I run a sumproduct. With the
calculations that I now need, I am not sure how to combine the sumproduct
with a sumif function to obtain totals.

My data sampling......

Date Creator Order # PreTaxed Amount
1/1/2007 XIAPPLXRP110 413457 231.54
1/17/2007 AVISD 413558 78.98
1/28/2007 SMITHA 413563 149.74
2/2/2007 XIAPPLXRP110 413573 42.41
2/5/2007 AVISD 413575 38.54
3/4/2007 HILTONA 413580 103.48
4/6/2007 AVISD 413584 28.37
9/1/2007 XIAPPLXRP110 413586 62.72

My current calculation: =SUMPRODUCT((MONTH('Raw Data
2007'!A2:A64868)=1)*('Raw Data 2007'!B2:B64868="XIAPPLXRP110"))
This calculation is to determine how many orders we have coming in via
XIAPPLXRP110 each month.

Now I would like to add another layer...I want to know the totals of the
orders coming in via XIAPPLXRP110, by the month rather than just counting the
number of orders.

Any help on this would be great. I need to get this ASAP for my emloyer.