Quote Originally Posted by Cutter View Post
Are the transaction codes numeric or text?

Are you familiar with SUMPRODUCT() function?
The transaction codes are numeric.

I've dabbled in SUMPRODUCT function the past few days but can't figure it out. I've come up with these formulas to work separately, but can't seem to put the two together. Here's what I have:

=SUMIF(B:B,"5*",C:C) to find the appropriate transaction codes that start with 5.

=SUMPRODUCT(($A$2:$A$1000>=40544)*($C$2:$C$1000<=40574)*($C$2:C$1000)) for transactions in rows A1-A1000 that are from 1/1/11 to 1/31/11.

Thanks.