You need to use SUMPRODUCT:

=SUMPRODUCT(--(A1:A10="Month"),--(B1:B10="Account"))

However, you may find that a pivot table is a more elegant solution for your
data analysis needs.

Dave
--
Brevity is the soul of wit.


"Michael" wrote:

Hi,

I have 2 worksheets, one sheet with the columns listed below and the other
sheet summarizes the activity entered in the first tab.

Column A = "Amount"
Column B = "Account"
Column C = "Month"

What I am trying to do is: SUMIF("Month"=Cell(C3) and "Account" = Cell(B6))
then return the "Amount" based on the criteria.

How would I create a formula to do just that?

Please let me know if need to further explain.